Browse by Tags

How do I find the CHECK constraints that depend on a specified CLR user-defined type?

Published 11 December 7 9:23 AM | SSQA.net

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...

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

TSQL to check whether the table has a column with the specified name?

Published 19 September 7 5:51 PM | SSQA.net

Within SQL Server 2005: if Exists( select * from sys.columns where Name = N '<ColumnName>' and Object_ID = Object_ID ( N '<TableName>' ) ) begin --write your own code print relevant code columns for existence end else begin...

Filed under: sql server, tsql, columns, check, tablename