Database Reference
In-Depth Information
11.6 Table Creation Statement
Once the database and tablespaces have been configured, the next logical step is to create
database objects which (in Oracle's case) will be stored in the tablespace(s). The first
type of database objects to be created is the relational and/or object tables; this is done
via the
Create-Table
statement. The
Create-Table
statement is one of the most multi-
faceted statements in SQL (next to the
Select
statement). The complete syntax is shown
in Figure
11-9
, while an abridged version of the statement is provided in Figure
11-10
.
Figure 11-9.
The Create-Table Statement