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.
idmscu19
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;
More information
  • For more information about defining keys, see CREATE KEY.