System table show if columns is part of PK?

[kim1]

Hi guys,

Is there any system table I can request to tell me if a columns is part of a primary key and Unique Key?

Table1
- ColA (PK)
- ColB (PK)
- ColC

ColA and ColB are Primary Keys

I have a loop that goes throught each column and I want to know if it is part of a primary key? or Unique Key? Is it possible?

Thanks for your help. Kim

 

[tlbroadbent]

I recommend using the INFORMATION_SCHEMA.TABLE_CONSTRAINTS view.

Use yourdatabase
go
Select *
From INFORMATION_SCHEMA.TABLE_CONSTRAINTS
Where (CONSTRAINT_TYPE='Unique'
Or CONSTRAINT_TYPE='Primary Key')

Also, see thread183-293476. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.