Skip to main content

SHOW TABLES

Show all the tables that are available in a source or Arctic catalog.

Syntax 
SHOW TABLES
    [ AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <reference_name> ]
    [ IN <catalog_name> ]

Parameters​

AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <reference_name> String   Optional

Specify a reference for which you want to show the available tables from. When this parameter is omitted, the current reference is used.

  • REF: Identifies the branch, tag, or commit that you want to show the available tables from.
  • BRANCH: Shows the available tables in the specified branch.
  • TAG: Shows the available tables in the specified tag.
  • COMMIT: Shows the available tables in the specified commit. Commit hashes must be enclosed in double quotes (for example, “ff2fe50fef5a030c4fc8e61b252bdc33c72e2b6f929d813833d998b8368302e2”).

IN <catalog_name> String   Optional

The name of the Arctic catalog used. When this parameter is omitted, the current Arctic catalog in the query context is used.

Examples​

Show the tables in the current source or Arctic catalog 
SHOW TABLES
Show tables at the specified reference in the current catalog 
SHOW TABLES
    AT REF myBranch
Show tables at the specified reference in the specified catalog 
SHOW TABLES
    AT BRANCH myBranch
    IN myCatalog