To determine if a table contains an IDENTITY column, run the following statement:
SELECT OBJECTPROPERTY(OBJECT_ID(N'[dbo].[Company]'),
'TableHasIdentity')
A value of 1 means that the specified table has an IDENTITY column while a value of 0 means the table doesn’t have an IDENTITY column. A value of NULL means either the table doesn’t exist or the object name passed is not a table.
To determine which column within a table is the IDENTITY column, run the following statement:
SELECT B.[Name] AS [IdentityColumn]
FROM [sys].[tables] A INNER JOIN [sys].[columns] B
ON A.[Object_ID] = B.[Object_ID] AND
A.[Name] = 'Company' AND
COLUMNPROPERTY(A.[Object_ID], B.[Name], 'IsIdentity') = 1