Lấy danh sách các constraint trong 1 table

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_NAME ='Employee AND TABLE_SCHEMA ='STTest;

Tham khảo: http://sqlthreads.wordpress.com/2010/04/01/get-the-list-of-all-the-constraints-in-a-table-in-sql-server/