Skip to end of metadata
Go to start of metadata

ClustrixDB provides partial, view-only support for some objects in INFORMATION_SCHEMA.

Supported Views

Read-only support is available for these INFORMATION_SCHEMA views. Column definitions and results may vary from MySQL. 

  • character_sets                 
  • collations                     
  • columns                        
  • events                         
  • files                          
  • key_column_usage               
  • partitions                     
  • processlist                    
  • referential_constraints        
  • routines                       
  • schemata                       
  • schema_privileges              
  • statistics                     
  • tables                         
  • table_constraints              
  • table_privileges               
  • triggers                       
  • user_privileges                
  • views                 

Unsupported Views

ClustrixDB does not support these objects:

  • collation_character_set_applicability
  • column_privileges
  • engines
  • global_status                
  • global_variables        
  • nbd_transid_mysql_connection_map
  • optimizer_trace
  • parameters
  • plugins
  • profiling
  • session_status     
  • session_variables
  • tablespaces

ClustrixDB-Specific Views

The follow are views specific to ClustrixDB:

View NameDescription
clx_function_privilegesFunction privileges granted to users
clx_procedure_privilegesProcedure privileges granted to users
global_variables_with_defaultsCurrent Global variables settings along with their default values
  • No labels