how do I find all primary keys in the sql server 2000 database ?

• sahmad43

  SSC Eights!

  Points: 926

  More actions

  August 25, 2008 at 2:11 pm

  #124989

  for finding foreign keys in sqlserver 200 there is a view sysforeignkeys

  but whats the view for finding out the primary kyes in sql 2000?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  August 25, 2008 at 2:26 pm

  #862792

  Try this:-

  select * from information_schema.table_constraints

  where constraint_type='PRIMARY KEY'

  HTH

  Manu

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 25, 2008 at 2:34 pm

  #862796

  This works. It's in the script section SSC - http://www.sqlservercentral.com/scripts/Miscellaneous/30755/

  Greg