CREATE TABLE AS

Create Table As Syntax Grammar.

Description

Creates a new table based on a query. The owner of this table is the user that issues the command.

For more information please refer to CREATE TABLE AS documentation.

Grammar Syntax

CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ]
TABLE table_name
[ ( column_name [, ... ] ) ]
[ BACKUP { YES | NO } ]
[ table_attributes ]
AS query

where table_attributes are:
[ DISTSTYLE { AUTO | EVEN | ALL | KEY } ]
[ DISTKEY( distkey_identifier ) ]
[ [ COMPOUND | INTERLEAVED ] SORTKEY( column_name [, ...] ) ]