How to identify tables which aren't used since long time

Database
Enthusiast

How to identify tables which aren't used since long time

My Aim: to identify tables which hadn’t been queried for a year or more and delete it to reclaim space.

Since there no view which reflect table usage I thought we can use DBQLogTbl which contains most system query text to get tablename which exist in TABLES view and it’s not referenced in SQLTEXT column in DBQLogTbl.

The logic can be like this but sure the syntax is wrong:

Select  * tables

Where tablename not like

(select sqltext from DBQLDBQQL);