Adding Integrity Constraints
Creating and Using Tables
Creating and Using Database Objects 3-7
Adding Integrity Constraints
You will now add different types of constraints to the tables you created in
To Add a NOT NULL Constraint Using the SQL Developer Interface:
You will add a
NOT NULL
constraint to the table using the SQL Developer graphical
interface.
1.
In the Connections navigation hierarchy, click the plus sign (+) next to Tables to
expand the list of tables.
2.
Right-click the
performance_parts
table.
3.
Select Edit.
4.
In the Edit Table window, follow these steps:
In the Edit Table window, click Columns.
In the Columns list, select
NAME
.
In the Column Properties section, check Cannot be NULL.
Click OK.
