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 an object is replaced, the old object is deleted and the new object is created in a single transaction.