Description

SHOW TABLES IN CATALOG is a SQL command used to list all tables in the specified catalog and schema.

Syntax

SHOW TABLES IN catalog_name.schema_name;

Parameter Description

• catalog_name: Specifies the name of the catalog for which to list the tables. Ensure that the provided catalog name exists and is accessible in the system.
• schema_name: Specifies the name of the schema for which to list the tables. This schema must belong to the aforementioned catalog.

Example

SHOW TABLES IN my_catalog.my_schema;

The above command will list all tables defined in the catalog named my_catalog and the schema my_schema.