DROP CALC

The DROP CALC data description statement deletes the definition of a CALC key from the dictionary. It is also a CA IDMS extension of the SQL standard.

Authorization

To issue a DROP CALC statement, you must own or have the ALTER privilege on the table on which the CALC key is defined.

Syntax

►►─── DROP CALC key FROM ─┬────────────────┬─ table-identifier ───────────────►◄
                          └─ schema-name. ─┘

Parameters

FROM table-identifier

Specifies the name of the table associated with the CALC key being dropped. Table-identifier must identify a base table on which a CALC key has been defined in the dictionary. The named table cannot contain any data (that is, the table must be empty).

schema-name

Identifies the schema associated with the named table.

If you do not specify schema-name, it defaults to:

The current schema associated with your SQL session, if the statement is entered through the Command Facility or executed dynamically
The schema associated with the access module used at runtime, if the statement is embedded in an application program

Usage

CALC Keys on Tables in the SYSTEM Schema

You cannot delete the definition of a CALC key on a table in the SYSTEM schema.

CALC Keys in the Implementation of Referential Constraints

You cannot drop a CALC key that is used in the implementation of a referential constraint if no existing index can be used in place of the CALC key.

Example

Dropping a CALC Key

The following DROP CALC statement deletes the definition of the CALC key associated with the COVERAGE table from the dictionary:

drop calc from coverage;

More Information

For more information about defining CALC keys, see CREATE CALC.
For more information about unlinked referential constraints, see CREATE CONSTRAINT.