Database Reference
In-Depth Information
Example 2:
The following example illustrates how the
check
constraints can be
specified during table creation.
Once your table has been created, you may view the structure of the table via the
Describe
statement, which has the following format:
Example 3:
The following statement will cause the structure of the table
Student
to
be listed on the screen.
You can also create a table from an existing table by feeding the output of a
Select
statement as the input to a
Create-Table
statement. The format of the
Create-Table
statement for this is:
The sub-query component of the statement is specified by a
Select
statement.
An example of this is provided below; this will be much clearer after you have been
introduced to the
Select
statement (next chapter).