Table, View, & Sequence DDL

.

Related Topics

• Databases, Tables & Views

• Using Sequences

• Database, Schema, & Share 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 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:

• Data Loading / Unloading DDL.

• DDL for User-Defined Functions, External Functions, and Stored Procedures.

In this Topic:

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

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.

• 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