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).
Search WWH ::




Custom Search