Categories:

DDL Commands

CREATE <object>

Creates a new object of the specified type.

See also:

ALTER <object> , DESCRIBE <object> , SHOW <objects>

Syntax

CREATE [ OR REPLACE ] <object_type> [ IF NOT EXISTS ] <object_name>
  [ <object_type_properties> ]
  [ <object_type_params> ]
  [ COMMENT = '<string_literal>' ]

Where object_type_properties and object_type_params are specific to the object type.

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

Account Objects:

Database Objects:

General Usage Notes

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