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.
For details about other schema-level objects (stages, pipes, UDFs, stored procedures, etc.), see:
In this Topic:
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¶
Use these commands to manage row access policies.
ALTER TABLE, ALTER EXTERNAL TABLE, and ALTER VIEW (to add/drop a policy on a table or view)