How to find out the columns of a PK with TSQL query?

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

NicHopper SSCrazy Eights Points: 9090 More actions · Answer 1

Hi,

I think this may be able to help you out;

SELECT SysT.Name AS TableName,

SC.Name AS ColumnName

FROM Sys.Tables SysT

INNER JOIN Sys.SysIndexKeys SysIK ON SysT.object_id = SysIK.id

INNER JOIN sys.syscolumns SC ON SysIK.colid = SC.colid AND SysIK.id = SC.id

WHERE SysT.Name = ''

AND SysIK.indid = 1

Let me know how you get on.

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 2

Another way is to use the information_schema.table_constraints view. Here is an example:

select *

from INFORMATION_SCHEMA.TABLE_CONSTRAINTS

where CONSTRAINT_TYPE = 'PRIMARY KEY' and TABLE_NAME = 'WriteTableNameHere'

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/