Information Schema

M-Compatibility继承了GaussDB的Information_Schema下的原有视图，具体请参考《开发指南》中“Schema > Information_Schema”章节。

M-Compatibility继承并改名的GaussDB的Information Schema视图见下表。

继承改名后的视图名称
_gs_foreign_data_wrappers
_gs_foreign_servers
_gs_foreign_table_columns
_gs_foreign_tables
_gs_user_mappings
gs_administrable_role_authorizations
gs_applicable_roles
gs_attributes
gs_character_sets
gs_check_constraint_routine_usage
gs_check_constraints
gs_collation_character_set_applicability
gs_collations
gs_column_domain_usage
gs_column_options
gs_column_privileges
gs_column_udt_usage
gs_columns
gs_constraint_column_usage
gs_constraint_table_usage
gs_data_type_privileges
gs_domain_constraints
gs_domain_udt_usage
gs_domains
gs_element_types
gs_enabled_roles
gs_foreign_data_wrapper_options
gs_foreign_data_wrappers
gs_foreign_server_options
gs_foreign_servers
gs_foreign_table_options
gs_foreign_tables
gs_information_schema_catalog_name
gs_key_column_usage
gs_parameters
gs_referential_constraints
gs_role_column_grants
gs_role_routine_grants
gs_role_table_grants
gs_role_udt_grants
gs_role_usage_grants
gs_routine_privileges
gs_routines
gs_schemata
gs_sequences
gs_table_constraints
gs_table_privileges
gs_tables
gs_triggered_update_columns
gs_triggers
gs_udt_privileges
gs_usage_privileges
gs_user_defined_types
gs_user_mapping_options
gs_user_mappings
gs_view_column_usage
gs_view_routine_usage
gs_view_table_usage
gs_views