SHOW SCHEMA

Use the SHOW SCHEMA command to list all of the schemas defined for the current database.

Syntax

Syntax for showing schemas:

SHOW SCHEMA

Inputs

The SHOW SCHEMA command has no inputs.

Privileges

You must be the admin user, the database owner, or you must have a privilege that allows you to connect to the current database.

Usage

In the following example, user1 can see only the schemas that user1 owns or is privileged to see:

DB1.USER1(USER1)=> SHOW SCHEMA;
 DATABASE | SCHEMA  | OWNER
----------+---------+-------
 DB1      | USER1   | USER1
 DB1      | BLUE    | USER1
 DB1      | TESTING | ADMIN

As the admin user or the database owner, you see all schemas in the database:

DB1.ADMIN(ADMIN)=> SHOW SCHEMA;
 DATABASE | SCHEMA             | OWNER
----------+--------------------+-------
      DB1 | ADMIN              | ADMIN
      DB1 | USER1              | USER1
      DB1 | BLUE               | USER1
      DB1 | DEFINITION_SCHEMA  | ADMIN
      DB1 | INFORMATION_SCHEMA | ADMIN
      DB1 | RED_SCHEMA         | USER2
      DB1 | USER2              | USER2
      DB1 | TESTING            | ADMIN

The sample output for the admin user shows the INFORMATION_SCHEMA and DEFINITION_SCHEMA. The system creates these schemas automatically in each database when the database is created and they cannot be modified by users.