To get Table and column name for Primary Keys.

,

This query will give you the table name and column name on which you have defined the primary key. You can use this to get columns on which the primary key is based. I find it very useful when i need to define the FK relationship for other tables in PowerDesigner. Try to do the same thing using system tables, i will really appreciate that, because i didn't find it that easy.



Mohit Nayyar
MCP, MCAD (.Net), MCSD, MCDBA

/*
This query will give you the table name and column name on which you have defined the primary key
*/

select a.Table_Name, a.Column_Name from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE a,
INFORMATION_SCHEMA.TABLE_CONSTRAINTS b
where b.constraint_type='PRIMARY KEY' and
a.constraint_name = b.constraint_name 
--and a.table_name='TableName'
order by a.table_name, a.column_name

Rate

5 (2)

Share

Share

Rate

5 (2)