Categories:
Overview of DDL Commands

CREATE

Creates a new object of the specified type.

See also:
ALTER , DESC , SHOW

Syntax

CREATE [ OR REPLACE ] <object_type> [ IF NOT EXISTS ] <identifier>
  [ <object_properties> ]
  [ <object_params> ]
  [ COMMENT = '<string_literal>' ]

Where object_properties and object_params are specific to the object_type.

For specific syntax, usage notes, and examples, see:

Account Objects:

Database Objects:

Usage Notes

  • OR REPLACE and IF NOT EXISTS clauses are mutually exclusive; they cannot both be used in the same statement.