Yang, Tong 3f5759eed2 MRS comp-lts 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2023-01-19 17:08:45 +00:00

4.1 KiB

Raw Permalink Blame History

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

4.1 KiB Raw Permalink Blame History