CREATE TABLE table [ (column [, ...] ) ] AS select_clause
The name of a new table to be created.
The name of a column. Multiple column names can be specified using a comma-delimited list of column names.
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.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.