Help Center/ Data Lake Insight/ SQL Syntax Reference (Paris Region)/ Spark SQL Syntax Reference/ Viewing Tables/ Viewing All Tables
Updated on 2022-12-07 GMT+08:00
View PDF
Share

Viewing All Tables

Function

This statement is used to query and show information about all tables and views in the current database.

Syntax

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

Keyword

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

Parameters

Table 1 Parameter description

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.

Precautions

None

Example

  1. Create an OBS or DLI table. For details, see Creating an OBS Table or Creating a DLI Table.
  2. To show all tables and views in the current database, run the following statement: 
    1
    		 
    SHOW TABLES;
  3. To show all tables started with test in the testdb database, run the following statement: 
    1
    		 
    SHOW TABLES IN testdb LIKE "test*";
Parent topic: Viewing Tables