Identity and Sequence both are used to generate auto-incrementing numbers. following are the differences:-
You can find more about Sequence click here
- Sequence is independent from table and Identity is a table dependent
- In Sequence New value can be obtain before an INSERT statement but Identity values generated when a row inserted into table
- In Sequence New values can be generate in an UPDATE statement but in Identity new value can not be generate in an UPDATE statement
- In Sequence, For performance point of view, you can set cache size option and also you can define min and max values, can allow cycling but You cannot define minimum and maximum values,allow cycling, and caching options or not in Identity column
You can find more about Sequence click here
No comments:
Post a Comment
Note: only a member of this blog may post a comment.