Deleting SQL Objects › Deleting a Schema

Deleting a Schema

You cannot use DROP to delete a schema. You must use the online CA Datacom Datadictionary Entity Maintenance (ENTMAINT) Mode to delete the authorization entity-occurrence that identifies the schema.

See the CA Datacom Datadictionary Online Reference Guide for information on using ENTMAINT Mode to delete an occurrence.

Before you can delete an SQL AUTHORIZATION occurrence, you must make certain it is not related to any existing occurrences (TABLE, VIEW, SYNONYM, PLAN) which use it as an authorization ID.

You can run a batch report to determine if the AUTHORIZATION occurrence is related to any other occurrences. See the CA Datacom Datadictionary Batch Reference Guide for information on running a Schema Report.