Post
Ask Question

Script for Finding the Identity Columns from Table

Script for All Identity Columns from all Tables:
  1. SELECT * FROM SYS.IDENTITY_COLUMNS  
Script for All Identity Columns from particular Tables:
  1. SELECT * FROM SYS.IDENTITY_COLUMNS  
  2. WHERE OBJECT_ID=OBJECT_ID('TABLE_NAME')