Next: CREATE TRIGGER
Up: Reference Manual
Previous: CREATE TABLE
Subsections
CREATE TABLE AS -- Creates a new table
CREATE TABLE table [ (column [, ...] ) ] AS select_clause
- table
- The name of a new table to be created.
- column
- The name of a column. Multiple column names can be specified
using a comma-delimited list of column names.
- select_clause
- A valid query statement. Refer to SELECT for a description
of the allowed syntax.
Refer to CREATE TABLE and SELECT for a summary of possible
output messages.
CREATE TABLE AS enables a table to be created from the contents of
an existing table. It is functionality equivalent to SELECT INTO, but
with perhaps a more direct syntax.
Bruce Momjian
2001-05-09