Determine Whether a Given Column Name Is an Identity or Not
There are actually two ways in which you can find out whether a given column name is an identity or not in SQL Server: Method One: Select ColumnProperty(Object_id(‘Table_Name’), ‘FieldName’, ‘IsIdentity’)