Databases Reference
In-Depth Information
When you click the Add button, the definition of the constraint is added to the list of constraints at the top of the
page. You can define as many constraints on a given table as necessary. Once you're done, simply continue with
the wizard:
8.
You're not going to create any Unique or Check constraints here, so stick with the defaults
and click
Next
.
The final step of the Create Table Wizard gives you the chance to confirm your request and, if desired, review the
code that will be executed. If you need to make changes to the table definition, you can use the buttons at the top of
the region to navigate back through the wizard steps. To view the code, click the arrow to the left of the
SQL
label to
expand the region, as shown in Figure
4-5
.
Figure 4-5.
Review the Create Table Wizard's SQL
9.
Review the text in the SQL region presented by the Create Table Wizard. Click
Create Table
to complete the wizard.
When you've successfully completed the wizard, you're taken back to the Object Browser, and the definition of
the
TICKETS
table is displayed. Take a moment to examine the definition of the table. You should see all the columns
that you defined listed. If you click the Constraints tab at the top of the definition region, you see a number of different
constraints including the primary-key constraint on
TICKET_ID
.
In the upper-left corner of the Object Browser is a select list that defines the object type being browsed. Use this
select list to choose Sequences. You see that APEX created a sequence called
TICKETS_SEQ
that will be used to fill
the
TICKET_ID
.
