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.