DROP
The DROP statement allows you to remove resources.
General format
EXEC SQL [ AT Database ]
 
  DROP Options
 
END-EXEC
Syntax rules
1. Options is passed to the driver without further checks. Refer to the database documentation for detailed syntax. Syntax errors, if any, are returned at runtime.
General Rules
1. Database identifies the active connection that will execute the query and must be previously defined using a Format 4 DECLARE statement.
Examples
Remove the customers table
exec sql
   drop table customers
end-exec