Home Forums Programming General identifying Identification fields using system tables (sqlserver2000) RE: identifying Identification fields using system tables (sqlserver2000)

  • July 17, 2004 at 6:16 pm

    #514990

    Very undocumented...

    select * from syscolumns where colstat & 1 = 1

    Will give the Identity columns

    /rockmoose


    You must unlearn what You have learnt