Deleting a key

You can delete keys from a database dictionary record. Remember, there is a direct correlation between the number of keys defined in a database dictionary record and the length of time it takes to add a record to that file.

A DROP INDEX statement is generated if a key is removed from the dbdict.

Note: If Service Manager determines it does not have rights to CREATE a TABLE it writes all database definition language (DDL) into files in the <RUN directory>/ddl folder and accepts changes to the dbdict without performing the DROP INDEX operation.

Related topics

Adding a key
Modifying a key
Arrayed structures
Alias fields
Methods for updating database dictionary records
Methods for deleting database dictionary records

Add a key as the first key
Insert a key between other keys
Add keys to bottom of the key list
Modify keys: Nulls and duplicates to unique
Delete a key