Updated on 2023-04-28 GMT+08:00

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.