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:
ALTER TABLE, ALTER EXTERNAL TABLE, and ALTER VIEW (to add/drop a policy on a table or view)