Find tables with names with specific suffix in Vertica database

Bart Gawrych - Dataedo Team Bart Gawrych 2019-10-31

Table of Contents:


    Query below finds tables which names end with specific sufix, e.g. tables which names end with 'dimension'.

    Query

    select table_schema,
           table_name
    from v_catalog.tables
    where table_name like '%dimension'
    order by table_schema,
             table_name;
    

    Columns

    • table_schema - name of schema table was found in
    • table_name - name of found table

    Rows

    • One row represents a table
    • Scope of rows: all found tables
    • Ordered by table name, table schema

    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.
    Accept