How to find which field is the Primary key using SQL? 1

[level1]

Is there any way to find which filed is the unique ID field in a table by using some type of SQL... i.e:

select * from Test_Db..syscolumns c
join Test_Db..sysobjects o on c.id = o.id
where o.name = 'table_Test'

The above example will find all column names for a given table.

I m looking for something similar for quering which field is the Unique identifier in a table. By looking on the sysobjects etc of the SQL server 2000 looks like im lost for now.

anybody knows the answer Please help???

 

[gmmastros]

Take a look at this thread183-1049647

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[level1]

nice one thanks

"exec sp_pkeys table_Test"