What Information Does the Schema Contain?

The schema contains data management tables with information about structure and management of database elements, including tables, schemas, queries, and permissions, and physical storage and organization of data tables of extents, chunk columns, chunks, and delete predicates.

Database Management Tables

Database Object

Table

Clustering Keys

clustering_keys

Columns

columns, external_table_columns

Databases

databases

Permissions

table_permissions, database_permissions, schema_permissions, permission_types, udf_permissions, sqream_catalog.table_default_permissions

Queries

saved_queries

Roles

roles, roles_memeberships

Schemas

schemas

Tables

tables, external_tables

Views

views

User Defined Functions

user_defined_functions

Data Storage and Organization Tables

Database Object

Table

Extents

Shows extents

Chunk columns

Shows chunks_columns

Chunks

Shows chunks

Delete predicates

Shows delete_predicates. For more information, see Deleting Data