Script to determine the identity tables and columns in the databases.
USE <DBNAME> --script to determine the table with the identity column select name, OBJECTPROPERTY(id, 'TableHasIdentity') AS TableHasIdentityCol from sysobjects where xtype = 'U' --script to determine the table and columne with the identity on SELECT OBJECT_NAME(id) as TblName, name as ColName FROM syscolumns WHERE status = 0x80 --script to determine the table and columne with the identity on using ColumnProperty SELECT OBJECT_NAME(id) as TblName, name as ColName FROM syscolumns WHERE COLUMNPROPERTY(id, name, 'IsIdentity') = 1