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¶

Event table management¶

External table management¶

Standard view management¶

Materialized view management¶

Sequence management¶

Column-level security management¶

Use these commands for Dynamic Data Masking and External Tokenization.

Row access policy management¶

Snowflake supports the following DDL commands and operations to manage row access policies: