Check Constraints Editor (Oracle)
Go Up to Oracle Object Editors
The Check Constraints Editor lets you modify and enable/disable check constraints.
To edit a check constraint
- Open an editor on the check constraint. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
| Tab | Settings and tasks | |
|---|---|---|
|
Definition |
Use the Enabled control to enable/disable the check constraint. You can also edit the condition in the Check Condition box. The Table Columns button acts a time saver in editing the condition. It opens a dialog that lets you select and paste column names into the check condition expression. | |
|
DDL View |
For details on using this tab, see Viewing the SQL/DDL for an Object. | |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.