Description

SHOW TABLES is a SQL command used to list all tables in the database. When using the WHERE is_external=true condition, this command will only list external tables.

Syntax

SHOW TABLES [IN schema_name] WHERE is_external=true;

Parameter Description

• schema_name: (Optional) The name of the schema whose tables are to be listed. If specified, the command will only list external tables within the specified schema.
• is_external: A boolean condition used to filter external tables.

Example

List all external tables in the current database.

SHOW TABLES WHERE is_external=true;

List all external tables defined in the my_schema schema.

SHOW TABLES IN my_schema WHERE is_external=true;