Drop table if it is 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]

See the same thread under SQL. Please don't double post.