Script for finding the identity columns from table November 11, 2014 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' ) Read more