Help Center > > Developer Guide> System Catalogs and System Views> Overview of System Catalogs and System Views

Overview of System Catalogs and System Views

Updated at: Dec 30, 2020 GMT+08:00

System catalogs store structured metadata of GaussDB(DWS). They are the source of information used by GaussDB(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.

In separation of duty, non-administrators have no permission to view system catalogs and views. In other scenarios, system catalogs and views are either visible only to administrators or visible to all users. Some of the following system catalogs and views have marked the need of administrator permissions. They are accessible only to administrators.

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel