.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 |