CREATE TABLE AS Syntax ( Object File System Form) | VantageCloud Lake - CREATE TABLE AS Syntax (Object File System Table Form)

{ CREATE MULTISET TABLE | CT } [ database_name. | user_name. ] table_name,
  STORAGE = TD_OFSSTORAGE 
  [, RETENTIONDAYS = <retention_days> ]
  [ , MAP = map_name [COLOCATE USING colocation_name ] ]
  AS_clause
  [ ORDER BY ( [ NO ORDER BY | order_column_name [,...] | order_column_expr [,...]  ] )
  [UNIQUE] PRIMARY INDEX [index_name] ( index_column_name [,...] ) [ NO PRIMARY INDEX ]
  [ PARTITION BY COLUMN | NOT PARTITIONED ] [;]

AS_clause

AS { source_table | subquery } WITH [NO] DATA [ AND [NO] STATISTICS ]

CREATE TABLE AS Syntax ( Object File System Form) | VantageCloud Lake - CREATE TABLE AS Syntax (Object File System Table Form) - Teradata VantageCloud Lake

Lake - Working with SQL