CXXMAINT (Maintain Directory) › CXXMAINT DELETE (Delete CXX Definitions) › Deleting Tables

Deleting Tables

If any tables still exist in the database to be deleted, those tables are deleted. Prior to Version 11.0 if any tables were left in a database, the delete of that database would fail, but beginning with Version 11.0, it is no longer necessary to delete table definitions in a database separately before deleting that database, even though it is still possible to do so.

Use the following to delete one or more tables within a database, but not the entire database.

Non-SQL Accessible Tables

See the CA Datacom Datadictionary Batch Reference Guide or CA Datacom Datadictionary Online Reference Guide for instructions on accomplishing the following. This procedure ensures that the Directory and the CA Datacom/DB definitions are in synchronization and that the unwanted table definitions no longer exist in either CA Datacom/DB.

1. Modify the entity-occurrence definitions in CA Datacom/DB for the database structure, deleting the unwanted tables.
2. Execute the CA Datacom/DB CATALOG function on the database.

SQL Accessible Tables

To delete tables accessed by SQL, use the SQL DROP TABLE statement (see the CA Datacom/DB SQL User Guide) which ensures that the Data Definition Directory (DDD) database remains synchronized with the Directory and CA Datacom/DB.

Note: A table can be deleted with the database open in the Multi-User Facility, as long as a specified table has no open User Requirements Tables.

If a table is a partition (Child), it may not be deleted. A Full Parent table may be deleted, however, with the result that all partitions (Children) are deleted.