Why does Datacom SQL DROP TABLE appear to take a long time?
Quite a bit of work may be needed when dropping an SQL Table. Here are excerpts from the CA Datacom® Core - 15.1 documentation.
Dropping a Table - The results of processing the DROP TABLE have a far reaching impact.
The DROP TABLE statement removes the table from the schema, obsoletes the table from the CA Datacom® Datadictionary™, and removes the table from the CA Datacom®/DB Directory. You must be the creator of the table, or have the authority to drop the table.
SQL Procedure to Delete a Table
For SQL accessible tables, you can use an SQL DROP TABLE statement to delete a table. However, the DROP TABLE statement obsoletes the table, which removes all versions and statuses of the table from the CA Datacom® Datadictionary™ databases, deletes the Directory definition, and deletes the data.