Checking for Constraints... 1

[Neil Toulouse]

Hi there!

How can I check for the existence of a constraint on a field? And on a table?

Basically I want to create one but not bother if it already exists.

TIA
Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[tran008]

SELECT t.Name as Table_Name, c.Name as Column_Name, d.Name as Default_Constraints_Name, d.definition as Default_Value
FROM sys.default_constraints d
LEFT JOIN sys.tables t ON d.parent_object_id = t.object_id
LEFT JOIN sys.columns c ON t.object_id = c.object_id AND d.parent_column_id = c.column_id

 

[Neil Toulouse]

Many thanks! Is there something similar for SQL2000?

Also can this command be adjusted to show indexes on tables?

TIA
Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[tran008]

This will give you what you wants:

exec sp_help 'YourTableName'

 

[Neil Toulouse]

Excellent! That will do nicely

Many thanks
Neil

I like work. It fascinates me. I can sit and look at it for hours...