Help Center/ MapReduce Service/ User Guide (Kuala Lumpur Region)/ MRS Cluster Component Operation Gudie/ Using CarbonData (for MRS 3.x or Later)/ CarbonData Syntax Reference/ DDL/ SHOW TABLES
Updated on 2022-08-12 GMT+08:00
View PDF
Share

SHOW TABLES

Function

SHOW TABLES command is used to list all tables in the current or a specific database.

Syntax

SHOW TABLES [IN db_name];

Parameter Description

Table 1 SHOW TABLE parameters

Parameter

Description

IN db_name

Name of the database. This parameter is required only when tables of this specific database are to be listed.

Usage Guidelines

IN db_Name is optional.

Examples

SHOW TABLES IN ProductDatabase;

System Response

All tables are listed.

Parent topic: DDL