SHOW
The SHOW keyword provides database and table information.
SHOW DATABASES
Show all databases:
sql
SHOW DATABASES;SHOW DATABASES;sql
+---------+
| Schemas |
+---------+
| public |
+---------+
1 row in set (0.01 sec)+---------+
| Schemas |
+---------+
| public |
+---------+
1 row in set (0.01 sec)Show databases by LIKE pattern:
sql
SHOW DATABASES LIKE 'p%';SHOW DATABASES LIKE 'p%';Show databases by where expr:
sql
SHOW DATABASES WHERE Schemas='test_public_schema';SHOW DATABASES WHERE Schemas='test_public_schema';SHOW TABLES
Show all tables:
sql
SHOW TABLES;SHOW TABLES;sql
+---------+
| Tables |
+---------+
| numbers |
| scripts |
+---------+
2 rows in set (0.00 sec)+---------+
| Tables |
+---------+
| numbers |
| scripts |
+---------+
2 rows in set (0.00 sec)Show tables in the test database:
sql
SHOW TABLES FROM test;SHOW TABLES FROM test;Show tables by like pattern:
sql
SHOW TABLES like '%prometheus%';SHOW TABLES like '%prometheus%';Show tables by where expr:
sql
SHOW TABLES FROM test WHERE Tables='numbers';SHOW TABLES FROM test WHERE Tables='numbers';SHOW CREATE TABLE
Shows the CREATE TABLE statement that creates the named table:
sql
SHOW CREATE TABLE [table]SHOW CREATE TABLE [table]For example:
sql
SHOW CREATE TABLE system_metrics;SHOW CREATE TABLE system_metrics;sql
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| system_metrics | CREATE TABLE IF NOT EXISTS system_metrics (
host STRING NULL,
idc STRING NULL,
cpu_util DOUBLE NULL,
memory_util DOUBLE NULL,
disk_util DOUBLE NULL,
ts TIMESTAMP(3) NOT NULL DEFAULT current_timestamp(),
TIME INDEX (ts),
PRIMARY KEY (host, idc)
)
ENGINE=mito
WITH(
regions = 1
) |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------++----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| system_metrics | CREATE TABLE IF NOT EXISTS system_metrics (
host STRING NULL,
idc STRING NULL,
cpu_util DOUBLE NULL,
memory_util DOUBLE NULL,
disk_util DOUBLE NULL,
ts TIMESTAMP(3) NOT NULL DEFAULT current_timestamp(),
TIME INDEX (ts),
PRIMARY KEY (host, idc)
)
ENGINE=mito
WITH(
regions = 1
) |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+