Modifying Indexes, CALC Keys, and Referential Constraints › Maintaining CALC Keys › Dropping a CALC Key

Dropping a CALC Key

To drop a CALC key from an empty table, use the SQL DDL DROP CALC statement.

If the table is not empty, you must drop and recreate it.

Note: For the steps involved in this process, see Chapter 30, “Modifying Schema, View, Table, and Routine Definitions".

Considerations

You cannot drop a CALC key that is required for implementation of a referential constraint if no index exists to support it. If necessary, either drop the constraint or create an index to support it before dropping the CALC key.

Example

In the following example, the CALC key is dropped from the EMPLOYEE table.

drop calc key from emp.employee;