Information Schema

M-Compatibility模式数据库继承了GaussDB原有的部分Information Schema视图，继承的视图如表1所示，视图的具体定义及视图信息请参见《开发指南》中“Schema”章节。

表1 M-Compatibility模式数据库继承GaussDB数据库的视图
_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	-