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`
Sequences	`identity_key`
Tables	`tables`, `external_tables`
Views	`views`
User Defined Functions	`user_defined_functions`

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.