SHOW statements
You can view all the databases in an account by using the SHOW DATABASES
statement. The syntax is as follows:
SHOW DATABASES [LIKE pattern]
where the LIKE
clause can be used to filter database names.
You can view all the tables in an account by using the SHOW TABLES
statement.
The syntax is as follows:
SHOW TABLES [FROM database] [LIKE pattern]
where the FROM
clause can be used to filter database names and the
LIKE
clause can be used to filter table names.
You can view all the measures for a table by using the SHOW MEASURES
statement.
The syntax is as follows:
SHOW MEASURES FROM database.table [LIKE pattern]
where the FROM
clause will be used to specify the database and table name and
the LIKE
clause can be used to filter measure names.