CREATE <object>

Creates a new object of the specified type.

See also:

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

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 the object is replaced, the old object deletion and the new object creation are processed in a single transaction.