.show tables

Returns a set that contains the specified table or all tables in the database.

Requires Database viewer permission.

.show tables
.show tables (T1, ..., Tn)

Output

Output parameter Type Description
TableName String The name of the table.
DatabaseName String The database that the table belongs to.
Folder String The table's folder.
DocString String A string documenting the table.

Output example

Table Name Database Name Folder DocString
Table1 DB1 Logs Contains services logs
Table2 DB1 Reporting
Table3 DB1 Extended info
Table4 DB2 Metrics Contains services performance information