Updated on 2025-10-23 GMT+08:00

Information Schemas

The M-compatible database inherits some of the original views under the GaussDB Information Schema. Table 1 shows the inherited views. For details about the view definitions and view information, see section "Schema" in Developer Guide.

Table 1 Views of GaussDB inherited by the M-compatible database

_gs_foreign_data_wrappers

gs_foreign_table_options

_gs_foreign_servers

gs_foreign_tables

_gs_foreign_table_columns

gs_information_schema_catalog_name

_gs_foreign_tables

gs_key_column_usage

_gs_user_mappings

gs_parameters

gs_administrable_role_authorizations

gs_referential_constraints

gs_applicable_roles

gs_role_column_grants

gs_attributes

gs_role_routine_grants

gs_character_sets

gs_role_table_grants

gs_check_constraint_routine_usage

gs_role_udt_grants

gs_check_constraints

gs_role_usage_grants

gs_collation_character_set_applicability

gs_routine_privileges

gs_collations

gs_routines

gs_column_domain_usage

gs_schemata

gs_column_options

gs_sequences

gs_column_privileges

gs_table_constraints

gs_column_udt_usage

gs_table_privileges

gs_columns

gs_tables

gs_constraint_column_usage

gs_triggered_update_columns

gs_constraint_table_usage

gs_triggers

gs_data_type_privileges

gs_udt_privileges

gs_domain_constraints

gs_usage_privileges

gs_domain_udt_usage

gs_user_defined_types

gs_domains

gs_user_mapping_options

gs_element_types

gs_user_mappings

gs_enabled_roles

gs_view_column_usage

gs_foreign_data_wrapper_options

gs_view_routine_usage

gs_foreign_data_wrappers

gs_view_table_usage

gs_foreign_server_options

gs_views

gs_foreign_servers

-