What are the restrictions of using SEQUENCE object?

 Posted by Niladri.Biswas on 5/16/2013 | Category: Sql Server Interview questions | Views: 2546 | Points: 40

There are some restrictions that one have to be aware of when using a SEQUENCE:

1) Unlike an IDENTITY column, the sequence values aren’t protected from UPDATE,
and the column that received the value can be modified.

2) There aren’t any unique constraints on a sequence value.

3) In a table, the sequence value may have gaps, because of a rollback or a SQL
Server service restart.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response