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

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.