CREATE TABLE AS
¶
Define a new table from existing tables.
Table of contents
Synopsis¶
CREATE TABLE table_ident AS { ( query ) | query }
Description¶
CREATE TABLE AS
will create a new table and insert rows based on the
specified query
.
Only the column names, types, and the output rows will be used from the
query
. Default values will be assigned to the optional parameters used for
the table creation.
For further details on the default values of the optional parameters, see CREATE TABLE.
Parameters¶
- table_ident:
The name (optionally schema-qualified) of the table to be created.
- query:
A query (
SELECT
statement) that supplies the rows to be inserted. Refer to theSELECT
statement for a description of the syntax.