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