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
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,668 reads
Stored procedure to return the list of columns of the primary key for a table. The name of the column for the result set is the name of the primary key for the table.
2006-09-14 (first published: 2006-09-07)
689 reads
This script is intended for SQL Server professionals that needs to have a quick snapshot from an environment with all relevant information about the databases. It's a compilation from multiple scripts, and works in SQL Server 2000.I think that works on 7.0 too, but may have some compilation issues.Don´t forget to see the section MANUAL […]
2003-04-28
4,705 reads
This script returns the Duplicate indexes on any database (if any). Compatible with SQL Server 2000 only. Latest update Checks for possible duplications and removes them. Further, additional fields are displayed to support decision making.
2003-02-20
1,123 reads
This script creates an error message with a valid error number, and alert associated with the error message. (everything when it doesn't exists). Then captures all the user indexes in the database and executes DBCC ShowContig for each one. It calculates the % of fragmentation on leaf level and fires the alert when is fragmented.Then […]
2002-09-10
2,291 reads
