TSQL: find out which table a constraint belongs to
TSQL: find out which table a constraint belongs to
SELECT OBJECT_NAME(o.parent_object_id) FROM sys.objects o WHERE o.name = 'ConstraintABC' AND o.parent_object_id <> 0
Achievement provides the only real pleasure in life
TSQL: find out which table a constraint belongs to
SELECT OBJECT_NAME(o.parent_object_id) FROM sys.objects o WHERE o.name = 'ConstraintABC' AND o.parent_object_id <> 0
Posted by SF at 3:48 pm
No comments:
Post a Comment