Thursday, June 14, 2012

CONSTRAINT

FIND OUT WHAT ARE CONSTRAINTS ARE AVAILABLE IN OUR DATABASE


use Databasename

select c.name as c_name, t.name as t_name

from sys.key_constraints c

join sys.tables t on t.object_id = c.parent_object_id --where t.name='Tablename'


No comments:

Post a Comment