The query below lists all tables that was modified in the last 30 days.
select tabschema as schema_name, tabname as table_name, alter_time as modify_date from syscat.tables where type in ('T') and alter_time > current date - 30 DAYS and tabschema not like 'SYS%' order by alter_time desc;
- database_name - schema name
- table_name - table name
- modify_date - last modify time of table by ALTER statement
- One row: represents one table in a schema
- Scope of rows: all tables which was last modified in the last 30 days in all schemas
- Ordered by: modify time descending