Description

This command is used to view information related to external schemas.

Syntax

SHOW SCHEMAS EXTENDED WHERE type='external';

Parameter Description

1. EXTENDED keyword: Adding this keyword will add an extra column (type) to distinguish between external schema (EXTERNAL SCHEMA) and managed schema (MANAGED SCHEMA).

2. WHERE <expr>: Supports filtering based on the fields displayed by show schemas. For example, using type='external' filters out all external schemas.

Example

1. View the list of all schemas:

   SHOW SCHEMAS;
   

2. View the list of all managed schemas:

   SHOW SCHEMAS EXTENDED WHERE type='managed';
   

3. View the list of all external schemas:

   SHOW SCHEMAS EXTENDED WHERE type='external';