DROP KEY

The DROP KEY statement deletes the definition of a procedure or table procedure key from the dictionary. It is also a CA IDMS extension of the SQL standard.

Authorization

To issue a DROP KEY statement, you must own or hold the ALTER privilege on the procedure or table procedure from which the key is being dropped.

Syntax

►►─── DROP KEY key-name ──────────────────────────────────────────────────────►

 ►─── FROM ─┬────────────────┬───┬─ procedure-identifier ───────┬─────────────►◄
            └─ schema-name. ─┘   └─ table-procedure-identifier ─┘

Parameters

key-name

Specifies the name of the key to be dropped. The key-name must identify a key defined in the dictionary.

FROM table-procedure-identifier

Specifies the table procedure from which the key is dropped.

procedure-identifier

Specifies the procedure from which the key drops.

schema-name

Identifies the schema associated with the named procedure or table procedure. If you do not specify a 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

Example

Dropping a Key

The following DROP KEY statement deletes the definition of the ORG1 key from the dictionary:

drop key org1 from emp.org;

Note: For more information about defining keys, see CREATE KEY.