SHOW TABLES Statement

Syntax

show_tables_statement ::=
    SHOW [AS JSON] (TABLES | TABLE table_name)

Semantics

The show tables statement provides the list of tables present in the system. If you want to know the details of a specific table, then you can use show table statement. If the named table does not exist then this statement fails.

Example 5-6 Show Tables

The following statement lists all the tables in the system.

SHOW TABLES

Output:

tables
  SYS$IndexStatsLease
  SYS$PartitionStatsLease
  SYS$SGAttributesTable
  SYS$StreamRequest
  SYS$StreamResponse
  SYS$TableStatsIndex
  SYS$TableStatsPartition
  Users2
  users

Example 5-7 Show Tables

The following statement lists all the tables in the system in JSON format.

SHOW AS JSON TABLES

Output:

{"tables" : [
    "SYS$IndexStatsLease",
    "SYS$PartitionStatsLease",
    "SYS$SGAttributesTable",
    "SYS$StreamRequest",
    "SYS$StreamResponse",
    "SYS$TableStatsIndex",
    "SYS$TableStatsPartition",
    "Users2",
    "users"
]}

Example 5-8 Show Tables

The following statement lists a specific table in the system.

SHOW TABLE users

Output:

tableHierarchy
  users