Find recently modified tables in Db2 database

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

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.