select o.name AS [Table Name], c.name AS [Column Name] 
from sysobjects o join syscolumns c 
on o.id = c.id
where o.type = 'U' and COLUMNPROPERTY(o.id, c.name, 'IsIdentity') = 1
order by 1

This page was last updated on May 01, 2006 04:28 PM.