Script for Finding the Identity Columns from Table

Rakesh Kalluri

12y1.3kCode

This code snippet show Script for Finding the Identity Columns from Table.

Script for All Identity Columns from all Tables:

SELECT * FROM SYS.IDENTITY_COLUMNS

Script for All Identity Columns from particular Tables:

SELECT * FROM SYS.IDENTITY_COLUMNS
WHERE OBJECT_ID=OBJECT_ID('TABLE_NAME')