Find out all the Primary Key and Foreign Key Constraints in a table

To find out all the Primary Key and Foreign Key Constraints in a table using Sql Server 2005, use the INFORMATION_SCHEMA views. These views help retrieve the meta data information in an efficient manner.

Here is a query that demonstrated how to retrieve primary and foreign key for all tables in a database:

USE
SELECT Table_Name as [Table], Column_Name as [Column],
Constraint_Name as [Constraint], Table_Schema as [Schema]
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
ORDER BY [Table], [Column]