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:

CREATE API INTEGRATION

CREATE CONNECTION

CREATE DATABASE , CREATE DATABASE … CLONE

CREATE DATABASE ROLE

CREATE NETWORK POLICY

CREATE NOTIFICATION INTEGRATION

CREATE RESOURCE MONITOR

CREATE ROLE

CREATE SECURITY INTEGRATION

CREATE SHARE

CREATE STORAGE INTEGRATION

CREATE USER

CREATE WAREHOUSE

Database Objects:

CREATE ALERT

CREATE EVENT TABLE

CREATE EXTERNAL FUNCTION

CREATE EXTERNAL TABLE

CREATE FILE FORMAT , CREATE FILE FORMAT … CLONE

CREATE FUNCTION

CREATE MASKING POLICY

CREATE MATERIALIZED VIEW

CREATE PASSWORD POLICY

CREATE PIPE

CREATE PROCEDURE

CREATE ROW ACCESS POLICY

CREATE SCHEMA , CREATE SCHEMA … CLONE

CREATE SECRET

CREATE SEQUENCE , CREATE SEQUENCE … CLONE

CREATE SESSION POLICY

CREATE STAGE , CREATE STAGE … CLONE

CREATE STREAM , CREATE STREAM … CLONE

CREATE TABLE , CREATE TABLE … CLONE

CREATE TAG

CREATE TASK , CREATE TASK … CLONE

CREATE VIEW

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.