Post reply

Check constraint

  • October 30, 2009 at 12:05 am

    #385681

    Hi there,

    In SSMS, I created Check constraint (named CK_FieldA) in TableA, but I could not see my CK_FieldA under "Constraints" folder. I could only see my Default constraint.

    Where can I find my CK_FieldA in SSMS?

    Thank you.

  • October 30, 2009 at 2:57 am

    #1072979

    try this

    select * from information_schema.CHECK_CONSTRAINTS

    you can view all constraint in this database

    or may be you not refresh your database.

  • October 30, 2009 at 4:21 pm

    #1073417

    Another way is to use following query

    select * from sys.sysconstraints

    where status = 4

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • November 1, 2009 at 8:44 pm

    #1073651

    Thank you for replying... my bad, I did not refresh it. I got the CHECK constraint under "Constraint" folder now. And the T-SQL is very helpful too.. Thanks guys 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply