Browse by Tags

• check
• databases
• dba
• function
• object_name
• requirement
• sysobjects
• tablename
• tsql
• udf
• user-defined function
• values

SQL Server TSQL to find complete CONSTRAINT information on a table catalog?
09 January 08 06:26 AM | SQL Master | 2 Comments   

I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name Read More...

Filed under: function, tsql, sql server, databases, tablename, constraint, values, requirement, dba

How do I find the CHECK constraints that depend on a specified CLR user-defined type?
11 December 07 08:23 AM | SQL Master | 2 Comments   

Here is the another TSQL script from BOL to find the CHECK constraints that depend on a specified CLR user-defined type? USE <database_name>; GO SELECT SCHEMA_NAME(o.schema_id) AS schema_name ,OBJECT_NAME(o.parent_object_id) AS table_name ,OBJECT_NAME(o.object_id) Read More...

Filed under: tsql, sql server, object_name, check, udf, user-defined function, sysobjects, constraint