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
Row Access Policy Management

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.

CREATE MASKING POLICY
ALTER MASKING POLICY (see also: ALTER TABLE, ALTER TABLE … ALTER COLUMN, and ALTER VIEW)
DROP MASKING POLICY
SHOW MASKING POLICIES
DESCRIBE MASKING POLICY

Row Access Policy Management¶

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

CREATE ROW ACCESS POLICY
ALTER ROW ACCESS POLICY
DROP ROW ACCESS POLICY
SHOW ROW ACCESS POLICIES
DESCRIBE ROW ACCESS POLICY
ALTER TABLE, ALTER EXTERNAL TABLE, and ALTER VIEW (to add/drop a policy on a table or view)