CREATE TABLE AS SQL - Language Statements CREATE TABLE AS Creates a new table 1998-09-22 CREATE TABLE table [ (column [, ...] ) ] AS select_clause 1998-09-22 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. 1998-09-22 Refer to CREATE TABLE and SELECT for a summary of possible output messages. 1998-09-22 CREATE TABLE AS enables a table to be created from the contents of an existing table. It has functionality equivalent to SELECT TABLE INTO, but with perhaps a more direct syntax.