create-table-as.rst

CREATE TABLE AS

Define a new table from existing tables.

Table of contents

• Synopsis
• Description
• Parameters

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 :ref:`sql-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 the SELECT statement for a description of the syntax.