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