List tables in Vertica database

Bart Gawrych - Dataedo Team Bart Gawrych 2019-09-17

Table of Contents:


    Query below lists all tables in a Vertica database.

    Query

    select table_schema,
           table_name
    from v_catalog.tables
    order by table_schema
             table_name;
    

    Columns

    • table_schema - schema name
    • table_name - table name

    Rows

    • One row represents one table in the database
    • Scope of rows: all tables in the database
    • Ordered by schema and table name

    Sample results

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept