Creates a new object of the specified type.
- See also:
CREATE [ OR REPLACE ] <object_type> [ IF NOT EXISTS ] <object_name> [ <object_type_properties> ] [ <object_type_params> ] [ COMMENT = '<string_literal>' ]
object_type_params are specific to the object type.
For specific syntax, usage notes, and examples, see:
General Usage Notes¶
IF NOT EXISTSclauses 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.