Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hudi/ Hudi SQL Syntax Reference/ DDL/ SHOW TABLE
Updated on 2022-11-18 GMT+08:00
View PDF

SHOW TABLE

Function

This command is used to display all tables in current database or all tables in a specific database.

Syntax

SHOW TABLES [IN db_name];

Parameter Description

Table 1 Parameters

Parameter

Description

IN db_name

Name of the specific database whose tables need to be all displayed.

Precautions

IN db_Name is optional. It is required only when you need to display all tables of a specific database.

Examples

SHOW TABLES IN hudidb;

System Response

All tables are listed.

Parent topic: DDL