SQL Tips #39 - Listing All Keys in a Database

This query lists every key constraint in a database with its schema and table.

The Query

SELECT DISTINCT
    Constraint_Name AS [Constraint],
    Table_Schema AS [Schema],
    Table_Name AS [TableName] 
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
ORDER BY Table_Name,Constraint_Name
GO

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags