Table, view, & sequence DDL¶

Tables and views are the primary objects created and maintained in database schemas:

• All data in Snowflake is stored in tables.
• Views can be used to display selected rows and columns in one or more tables.

Sequences are also schema-level objects. Sequences can be used to generate unique numbers across sessions and statements or to generate values for a primary key or any column that requires a unique value.

Table management¶

• CREATE TABLE
• CREATE TABLE … CLONE
• CREATE TABLE … CONSTRAINT
• ALTER TABLE
• ALTER TABLE … ALTER COLUMN
• ALTER TABLE … CONSTRAINT
• DROP TABLE
• UNDROP TABLE
• SHOW TABLES (also SHOW OBJECTS)
• SHOW COLUMNS
• DESCRIBE TABLE
• DESCRIBE SEARCH OPTIMIZATION

Event table management¶

• CREATE EVENT TABLE
• ALTER TABLE (event tables)
• DROP TABLE
• SHOW EVENT TABLES
• DESCRIBE EVENT TABLE

External table management¶

• CREATE EXTERNAL TABLE
• ALTER EXTERNAL TABLE
• DROP EXTERNAL TABLE
• SHOW EXTERNAL TABLES (also SHOW OBJECTS)
• DESCRIBE EXTERNAL TABLE

Standard view management¶

• CREATE VIEW
• ALTER VIEW
• DROP VIEW
• SHOW VIEWS (also SHOW OBJECTS)
• SHOW COLUMNS
• DESCRIBE VIEW

Materialized view management¶

• CREATE MATERIALIZED VIEW
• ALTER MATERIALIZED VIEW
• DROP MATERIALIZED VIEW
• SHOW MATERIALIZED VIEWS
• DESCRIBE MATERIALIZED VIEW

Sequence management¶

• CREATE SEQUENCE
• CREATE SEQUENCE … CLONE
• ALTER SEQUENCE
• DROP SEQUENCE
• SHOW SEQUENCES
• DESCRIBE SEQUENCE

Column-level security management¶

Use these commands for Dynamic Data Masking and External Tokenization.

Row access policy management¶