SEQUENCE is a user-defined, schema-bound object that generates a sequence of
numeric values. The values generated by the sequence can be ascending or descending,
starting from any defined value. The value numbers can be cyclic, repeated until
reaching the upper or lower value.It has been introduced since SQL Server 2012 (code name DENALI).Unlike an IDENTITY column, a SEQUENCE object isn’t linked to any table, so any required relationships have to be managed from the application.
Asked In: Many Interviews |