• Data Warehouse Service

  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. Overview of System Catalogs and Views

Overview of System Catalogs and Views

System catalogs store structured metadata of DWS. They are the source of information used by DWS to control system running and are a core component of the database system. System views provide ways to query system catalogs and internal database status.

You can delete and recreate the catalogs, add columns to them, and insert and update values in them, but doing so may make system information inconsistent and cause system faults. Generally, users should not modify system catalogs and system views, or rename the corresponding schemas. They are automatically maintained by the system.

Do not add, delete, or modify system catalogs because doing so will result in exceptions or even cluster unavailability.