.show tables command

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

Note

For table statistics, see the .show table data statistics command.

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.

Syntax

.show tables [(TableName [, ...])]

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
TableName	string		The name of the table to show.

Returns

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.

Example

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

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