Home Forums SQL Server 7,2000 T-SQL List of Identity Columns in Database RE: List of Identity Columns in Database

  • September 23, 2004 at 7:27 am

    #524160

    select  * from syscolumns where autoval is not null

    will list the columns, but you need to know what you are doing if you want to add tablenames, etc