Hi,
You can also try this.
SELECT * FROM DBC.TABLES WHERE DATABASENAME = AND TABLENAME LIKE ANY ( '%_2809', '%_1308', '%_BKP' ,'%_TMP' ,'%_HIST' ) ;
Thanks,
Shashank Jain
Attachments
Library
Quick Reference
Archives
Sample Index
2011 Indexes