This will do it for a specific database. cheers .

SELECT sysobjects.name as 'Table Name', syscolumns.NAME AS 'Identiy Column Name'

FROM   syscolumns, sysobjects

WHERE  syscolumns.ID = sysobjects.ID...

The AUTOVAL column of the syscolumns table is NOT NULL if the column has the identity on. The following query illustrate an exampe. In combination with information in the view INFORMATION_SCHEMA.COLUMNS you can...