IDENTITY COLUMNS /AUTO INCREEMENT

Identity column is a column whose value increases automatically as and when data is inserted into the table. The value in an identity column is created by the server. A user cannot insert a value into an identity column; it’s created by the server.

Identity column can be used to uniquely identify the rows in the table and acts like a primary key field.

SYNTAX

 
 

PRACTICE YOURSELF 

Want More SQL Deep Dives

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin