Information Schema
M-Compatibility模式数据库继承了GaussDB原有的部分Information Schema视图，继承的视图如表1所示，视图的具体定义及视图信息请参见《开发指南》中“Schema”章节。
_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 | - |
- character_sets
- collations
- collation_character_set_applicability
- columns
- column_privileges
- engines
- events
- files
- global_status
- global_variables
- key_column_usage
- optimizer_trace
- parameters
- partitions
- plugins
- processlist
- profiling
- referential_constraints
- routines
- schemata
- schema_privileges
- session_status
- session_variables
- statistics
- tables
- table_constraints
- table_privileges
- triggers
- user_privileges
- views
