Viewing All Tables

Updated on 2024-08-19 GMT+08:00

View PDF

This statement is used to check all tables and views in the current database.

    
       SHOW TABLES [IN | FROM db_name] [LIKE regex_expression];

FROM/IN: followed by the name of a database whose tables and views will be displayed.

**Table 1** Parameters
Parameter	Description
db_name	Database name, which consists of letters, digits, and underscores (_). The value cannot contain only digits or start with a digit or underscore (_).
regex_expression	Name of a database table.

None

Create a table. For details, see Creating an OBS Table or Creating a DLI Table.
To show all tables and views in the current database, run the following statement:
1

SHOW TABLES;
To show all tables started with test in the testdb database, run the following statement:
1

SHOW TABLES IN testdb LIKE "test*";