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 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, etc.), see:

In this Topic:

Sequence Management