Previous Topic: Deleting a DatabaseNext Topic: How to Use

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

Deleting Tables

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 helps ensure that the Directory and the CA Datacom Datadictionary definitions are in synchronization and that the unwanted table definitions no longer exist in either CA Datacom Datadictionary or CA Datacom/DB.

  1. Modify the entity-occurrence definitions in CA Datacom Datadictionary for the database structure, deleting the unwanted tables.
  2. Execute the CA Datacom Datadictionary CATALOG function on the database.
SQL Accessible Tables

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

Note: A table can be deleted with the database open in the MUF, 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.