Hi, Tariq
You may have to loop through the directory, opening each table and doing a reccount() or a select * and check the _tally to see if greater than zero. If the count is zero, the table is empty and can be deleted.

HTH
Beth
>Dear Experts
>
>There are five Tables in a directory entitled "TEMP"
>Two tables have data and the rest three are empty.
>
>I want to delete empty tables programatically.
>How is it possible?
>
>Please help.