Hi sowmiya23 ,
Another alternative beside using loop from dropping the table is counting the content of desired dropped table in a variable, checking its content whether it is empty ( if it not use, it means the table even haven't been created ), or there's exist a value inside the table.
Example :
LET vCheck = NoOfRows('table that wants to be checked'); -> this can be coupled with looping
This will count the number of rows inside it, for checking.
For dropping the table :
IF IsNull(TableNumber('table that wants to be checked')) THEN -> table number is the number of table, if not exist then it should be no value returned.
DROP Table 'The table that wants to be checked'; -> if you previously used looping, everytime it loop, it should be changes. Don't know about using the name of the table inside a variable, to make it more flexible.
Dont forget, every time using an IF THEN , close it with
ENDIF;
Not completely sure this will work, but at least the point is, there's a way to check which table is not containing anything, and using expression to drop it.
Hope it's help
Kevin
