SQL Server - Constraints

Question

I have a table in SQL Server and underneath, there is a constraints folder. How can I view the constraints in that folder? I didn't see a modify constraint to where I can view it.

marc_s · Accepted Answer · 2011-12-23 15:58:02Z

3

What do you mean by modify constraint ??

If you're talking about SQL Server Management Studio and its Object Explorer - you can right-click on the Constraints node for any given table and choose Add constraint - is that what you're looking for??

If you want to change an existing constraint. you need to click on that constraint and typically you need to script that out to drop and then re-create that constraint

enter image description here

You cannot just modify it "in place" (there's no Modify Constraint dialog box or anything like that).

edited Dec 23, 2011 at 15:58

answered Dec 23, 2011 at 15:42

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bassam Mehanni · Accepted Answer · 2011-12-23 15:42:07Z

0

You can just right click it and choose script as Create to a new query window to see what it is.

answered Dec 23, 2011 at 15:42

Bassam Mehanni

14.9k2 gold badges35 silver badges41 bronze badges

Collectives™ on Stack Overflow

SQL Server - Constraints

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related