CREATE <object>¶

语法¶

CREATE [ OR REPLACE ] <object_type> [ IF NOT EXISTS ] <object_name>
  [ <object_type_properties> ]
  [ <object_type_params> ]
  [ COMMENT = '<string_literal>' ]

其中 object_type_properties 和 object_type_params 特定于对象类型。

有关具体语法、使用说明和示例，请参阅：

账户对象：

• CREATE API INTEGRATION

• CREATE APPLICATION

• CREATE APPLICATION PACKAGE

• CREATE AUTHENTICATION POLICY

• CREATE CATALOG INTEGRATION

• CREATE COMPUTE POOL

• CREATE CONNECTION

• CREATE DATABASE、CREATE DATABASE ...CLONE

• CREATE DATABASE ROLE

• CREATE EXTERNAL ACCESS INTEGRATION

• CREATE EXTERNAL VOLUME

• CREATE FAILOVER GROUP

• CREATE NETWORK POLICY

• CREATE NOTIFICATION INTEGRATION

• CREATE REPLICATION GROUP

• CREATE RESOURCE MONITOR

• CREATE ROLE

• CREATE SECURITY INTEGRATION

• CREATE SHARE

• CREATE STORAGE INTEGRATION

• CREATE USER

• CREATE WAREHOUSE

数据库对象：

• CREATE AGGREGATION POLICY

• CREATE ALERT

• CREATE AUTHENTICATION POLICY

• CREATE DATA METRIC FUNCTION

• CREATE DYNAMIC TABLE

• CREATE EVENT TABLE

• CREATE EXTERNAL FUNCTION

• CREATE EXTERNAL TABLE

• CREATE FILE FORMAT、CREATE FILE FORMAT ...CLONE

• CREATE FUNCTION

• CREATE GIT REPOSITORY

• CREATE HYBRID TABLE

• CREATE ICEBERG TABLE

• CREATE IMAGE REPOSITORY

• CREATE LISTING

• CREATE MASKING POLICY

• CREATE MATERIALIZED VIEW

• CREATE MODEL

• CREATE NETWORK RULE

• CREATE PACKAGES POLICY

• CREATE PASSWORD POLICY

• CREATE PIPE

• CREATE PROCEDURE

• CREATE PROJECTION POLICY

• CREATE ROW ACCESS POLICY

• CREATE SCHEMA、CREATE SCHEMA ...CLONE

• CREATE SECRET

• CREATE SEQUENCE、CREATE SEQUENCE ...CLONE

• CREATE SERVICE

• CREATE SESSION POLICY

• CREATE SNAPSHOT

• CREATE STAGE、CREATE STAGE ...CLONE

• CREATE STREAM、CREATE STREAM ...CLONE

• CREATE STREAMLIT、

• CREATE TABLE、CREATE TABLE ...CLONE

• CREATE TAG

• CREATE TASK、CREATE TASK ...CLONE

• CREATE VIEW

类：

• CREATE SNOWFLAKE.ML.ANOMALY_DETECTION

• CREATE BUDGET

• CREATE SNOWFLAKE.ML.CLASSIFICATION

• CREATE CUSTOM_CLASSIFIER

• CREATE SNOWFLAKE.ML.FORECAST

一般使用说明¶

• OR REPLACE 和 IF NOT EXISTS 子句是互斥的，它们不能在同一语句中使用。

• CREATE OR REPLACE <object> 语句是原子的。也就是说，当对象被替换时，旧对象将被删除，新对象将在单个事务中创建。