Constraint Information | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Constraint Information

Hi All.. I have a list of table names.I want to know the constraints attached to each table and the columns attached to each constraint. what is the query to get this information. help me. Thanx
Rajesh
sp_MSforeachtable ‘SP_HELPCONSTRAINT "?"’ – which is undocumented stored procedure but will do for the time being and better than querying system tables. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
You might want to have a look at BOL for the INFORMATION_SCHEMA views. —
Frank
http://www.insidesql.de

]]>