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 [, ...] ) ]
Last updated