"alan" <an*******@devdex.com> wrote in message news:40***********************@news.frii.net...
What query do I use to list the primary key for each user table, i.e.
TABLE | PRIMARY_KEY |
Regards,
Alan
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
USE pubs
go
SELECT KU.*
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KU
ON TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND
TC.CONSTRAINT_NAME = KU.CONSTRAINT_NAME
ORDER BY KU.TABLE_NAME, KU.ORDINAL_POSITION
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME
COLUMN_NAME ORDINAL_POSITION
pubs dbo UPKCL_auidind pubs dbo authors au_id 1
pubs dbo PK_emp_id pubs dbo employee emp_id 1
pubs dbo PK__jobs__117F9D94 pubs dbo jobs job_id 1
pubs dbo UPKCL_pubinfo pubs dbo pub_info pub_id 1
pubs dbo UPKCL_pubind pubs dbo publishers pub_id 1
pubs dbo UPKCL_sales pubs dbo sales stor_id 1
pubs dbo UPKCL_sales pubs dbo sales ord_num 2
pubs dbo UPKCL_sales pubs dbo sales title_id 3
pubs dbo UPK_storeid pubs dbo stores stor_id 1
pubs dbo UPKCL_taind pubs dbo titleauthor au_id 1
pubs dbo UPKCL_taind pubs dbo titleauthor title_id 2
pubs dbo UPKCL_titleidind pubs dbo titles title_id 1
Regards,
jag