- Overview of DDL Commands
Creates a new object of the specified type.
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 object-specific syntax, usage notes, and examples, see:
Database and Schema Objects:
- OR REPLACE and IF NOT EXISTS clauses are mutually exclusive; they cannot both be used in the same statement.