information_schema
database that is available by default on server startup. You can query system tables in the same way as regular tables, and you can use the SHOW CREATE TABLE
command to view the table schemas.users
system table provides information about all database users and contains the following columns:databases
system table provides information about all created databases on the server and contains the following columns:permissions
system table provides information about all user/role permissions for all database objects and contains the following columns:role_name
column identifies a user or a role.roles
system table lists all created database roles and contains the following columns:tables
system table provides information about all database tables and contains the following columns:DEFAULT
, VIEW
, TEMPORARY
, and FOREIGN
.CREATE TABLE
DDL statement for table.dashboards
system table provides information about created dashboards (enterprise edition only) and contains the following columns:role_assignments
system table provides information about database roles that have been assigned to users and contains the following columns:memory_summary
system table provides high level information about utilized memory across CPU and GPU devices and contains the following columns:CPU
and GPU
.memory_details
system table provides detailed information about allocated memory segments across CPU and GPU devices and contains the following columns:CPU
and GPU
.FREE
and USED
.storage_details
system table provides detailed information about utilized storage per table and contains the following columns:information_schema
database, along with the system tables that they use.information_schema
database can access the system dashboards."ui/enable_crosslink_panel": true
to the feature_flags
section of the servers.json file.