tag:blogger.com,1999:blog-12039988.post114423954521019780..comments2023-10-01T12:49:34.417+01:00Comments on adventures with my beard: TSQL Script to Find All Identity Columns in a DatabaseDavid Kemphttp://www.blogger.com/profile/03848249444223250254noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-12039988.post-86055232571517942752008-04-23T20:59:00.000+01:002008-04-23T20:59:00.000+01:00Here a version for SQL server 2005:select distinct...Here a version for SQL server 2005:<BR/><BR/>select distinct<BR/> so.Name [Table],<BR/> sc.Name [Identity Column]<BR/>from <BR/> sys.columns sc<BR/> inner join sys.objects so on sc.object_id = so.object_id <BR/>where<BR/> is_Identity = 1<BR/>order by<BR/> 1<BR/><BR/>#Jean.Anonymousnoreply@blogger.com