Previous Next JavaScript must be enabled to correctly display this content

## 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-7 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-8 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-9 Show Tables

The following statement lists a specific table in the system.

    SHOW TABLE users

Output:

    tableHierarchy
      users