Query for Drop table if already exists

[mindus]

In progress SQL-92/4GL how can drop table if alread exists in database


For example in sql server
IF OBJECT_ID ('dbo.customer','U') IS NOT NULL
Drop table customer;

Like that how can do the same thing in progress database.

Can anyone please give the exact query how to drop the table if it is exists already in database

Thanks
mindus

 

[tamhas]

How would you drop a table that didn't exist?

Most of the time I have just seen people drop tables unconditionally and accept and ignore the error message if it didn't exist.

 

[mindus]

I just need if it is exist how can check it with 'if condition'.

Thanks
mindus