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 }