What Information Does the Schema Contain?

The schema includes tables designated and relevant for both external and internal use:

External Tables

The following table shows the data objects contained in the sqream_catalog schema designated for external use:

Database Objects

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

Internal Tables

The following table shows the data objects contained in the sqream_catalog schema designated for internal use:

Storage Objects

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.