Home Forums Article Discussions Article Discussions by Author Discuss content posted by Scott Solice How do you find out all the IDENTITY columns of all the tables in a given database? RE: How do you find out all the IDENTITY columns of all the tables in a given database?

  • January 7, 2010 at 7:16 am

    #1100185

    SELECT * FROM syscolumns WHERE columnproperty(id,column_name,isidentity) = 1