On this page

    SHOW TABLES

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

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

    Parameters

    AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <refValue>

    String

    Optional

    This parameter applies to only Arctic catalogs. 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

    This parameter applies to only Arctic catalogs. 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