Names of columns in the Primary Key

• consciouspnm

  SSC-Addicted

  Points: 490

  More actions

  September 15, 2005 at 10:18 am

  #89042

  How do I get the names of all the columns in the primary key using TSQL in a form I can loop round with a cursor.

  Assume I know how to get the table id from sysobjects and the column names from syscolumns (and I know I shouldn't really be using the system tables!)?

   

   

• noeld

  SSC Guru

  Points: 96590

  More actions

  September 15, 2005 at 10:20 am

  #590220

  sp_pkeys @table_name =  'YourTableName'

  
  * Noel

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  September 15, 2005 at 10:26 am

  #590221

  See the catalog views in the master database owned by the special "user" INFORMATION_SCHEMA

  For primary keys, see view INFORMATION_SCHEMA.KEY_COLUMN_USAGE

  SQL = Scarcely Qualifies as a Language