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.
| 
       _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
 
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot