Find SQL Tables with Identities
SELECT
OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME) ObjectId,
IDENT_SEED(TABLE_SCHEMA + '.' + TABLE_NAME) AS Seed,
IDENT_INCR(TABLE_SCHEMA + '.' + TABLE_NAME) AS Increment,
IDENT_CURRENT(TABLE_SCHEMA + '.' + TABLE_NAME) AS Current_Identity,
TABLE_SCHEMA + '.' + TABLE_NAME AS Table_Name
FROM
INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY(OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME), 'TableHasIdentity') = 1