Querying for identity columns

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  October 6, 2005 at 5:12 pm

  #69886

  Guys,

       I am trying to query the database to find all columns which have identity property

  I have tried querying the syscolumns and also  tried to use information schema views, but I cudn't get far

  Please let me if you have any other way to find it out

  Thanks

   

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  October 6, 2005 at 5:55 pm

  #595733

  Don't you just query syscolumns for entries where colstat = 1?

  David