Find recently created tables in Vertica database

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

Table of Contents:


    Query below lists all tables that were created within the last 30 days

    Query

    select table_schema,
           table_name,
           create_time
    from v_catalog.tables
    where create_time > CURRENT_TIMESTAMP - interval '30 day'
    order by create_time desc;
    

    Columns

    • schema_name - schema name
    • table_name - table name
    • create_time - table creation date

    Rows

    • One row represents one table in a database
    • Scope of rows: all tables in Vertica database that were created within last 30 days
    • Ordered by table creation date (descending)

    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