ident

SELECT
o.name AS table_name,
c.name AS column_name,
t.name AS data_type,
c.colid,
CASE WHEN c.status & 0x80 != 0 THEN 'IDENTITY' ELSE '' END AS identity_flag
FROM sysobjects o
JOIN syscolumns c ON o.id = c.id
JOIN systypes t ON c.usertype = t.usertype
WHERE o.type = 'U'
ORDER BY o.name, c.colid;