SQL Server:How to obtain column names on which primary key is defined? 1

[AnythingAboutPB]

Hello Everybody,

How to query database so that it will display list of columns on which primary key is defined.
I am using MS-SQL Server 2000.

Thanks and Regards
Mahesh.

 

[nigelrivett]

http://www.nigelrivett.net/ColumnsInPK.html

declare @TableName varchar(128)
select @TableName = 'mytbl'

select c.COLUMN_NAME
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,
INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
where pk.TABLE_NAME = @TableName
and CONSTRAINT_TYPE = 'PRIMARY KEY'
and c.TABLE_NAME = pk.TABLE_NAME
and c.CONSTRAINT_NAME = pk.CONSTRAINT_NAME


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.