Find recently created tables in Vertica database

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