Use a script with SQL commands to "drop" a table using the SQL Explorer tool:
proenv> proserve sports2000 -S 7700
proenv> sqlexp sports2000 -S 7700 -H localhost -user <username> -password <password> -infile dropcust.sql
"dropcust.sql" contains the 2 following lines:
DROP TABLE pub.customer;
COMMIT WORK;
DROP TABLE, is like the DATA DICTIONARY Delete Table.
Both delete the records beforehand.
DROP TABLE doesn't use ABL TRIGGERS, you'd need java triggers instead.
For example if there's a DELETE trigger on checking that there are no associated outstanding parent/child records to the table-record being deleted, that won't happen with DROP TABLE.
The user connecting to the database needs to have DBA rights and permissions in the database.
