SQL Server Performance Forum – Threads Archive

Defaults Values etc

is it possible to list for an entire DB all of the following All constraints
All Foreign Keys
All Defaults values

SELECT
CAST(OBJECT_NAME(constid) AS CHAR(35))
FROM
sysconstraints might be one way. Generally you should prefer the INFORMATION_SCHEMA views. ———————–
–Frank
http://www.insidesql.de
———————–

<pre id="code">select * from INFORMATION_SCHEMA.CHECK_CONSTRAINTS </pre id="code"> INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE for table usage INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE for column usage … this is preferred method rather than querying directly the system tables. [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

]]>