Data Definition (DDL) Syntax

Data Definition Operations

Create Table:

CREATE TABLE table_name {( [
        { column_name data_type [ column_constraint [ ... ] ]
        | table_constraint }
        [PRIMARY KEY (column)]
        [INDEX (column)]
        [PARTITION BY]
        [BROADCAST]
        ] )
        |
        AS SELECT column [, column]*
        FROM table_name
        [WHERE booleanExpression]
        }

 

DropTable:

DROP TABLE [ IF EXISTS ] name

 

Describe:

DESCRIBE DATABASE databaseName
        | DESCRIBE CATALOG [ databaseName . ] catalogName
        | DESCRIBE SCHEMA [[ databaseName . ] catalogName ] . schemaName
        | DESCRIBE TABLE ] [[[ databaseName . ] catalogName ] . schemaName. ] tableName [columnName ]
        | DESCRIBE [ STATEMENT ] { query }