Working with Constraints
You can perform the following operations after a table is created only for a Regular table:
Creating a Constraint
Follow the steps below to add a new constraint to the existing table:
- Right-click the selected constraint of the table and select Create constraint.
The Add New Constraint dialog box is displayed prompting you to add information about the new constraint.
- Enter the Constraint Name, Check Expression, and click Add. You can view the added constraint in the corresponding table.
Data Studio displays the status of the operation in the status bar.
The status bar will show the name of the constraint if it has been provided in the Constraint Name field, or else the constraint name will not be displayed as it is created by database server.
Renaming a Constraint
Follow the steps below to rename a constraint:
- Right-click the selected constraint and select Rename Constraint.
The Rename Constraint dialog box is displayed prompting you to provide the new name.
- Enter the constraint name and click OK. Data Studio displays the status of the operation in the status bar.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
