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>' ]
Copy

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:

Classes:

General Usage Notes¶

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

  • CREATE OR REPLACE <object> statements are atomic. That is, when an object is replaced, the old object is deleted and the new object is created in a single transaction.