DROP INDEX

---

This statement drops a specific index from a designated table.

Syntax

DROP INDEX [ table-name . ] index-name [ IN DICTIONARY ] 

Remarks

The IN DICTIONARY keyword allows you to drop an index from a DDF without removing the index from the underlying data file.

IN DICTIONARY is a very powerful and advanced feature. It should only be used by system administrators or when absolutely necessary. Normally, the SRDE keeps DDFs and data files perfectly synchronized, but this feature allows users the flexibility to force out-of-sync table dictionary definitions to match an existing data file. This can be useful when you want to create a definition in the dictionary to match an existing data file.

---

Caution
Modifying a DDF without performing parallel modifications to the underlying data file can cause serious problems.

---

For more information on this feature, see the discussion under IN DICTIONARY .

Examples

The following statement drops the named index from the Faculty table.

DROP INDEX Faculty.Dept 

---

The following examples create a "detached" table, one with no associated data file, then add and drop an index from the table definition. The index is a detached index because there is no underlying Btrieve index associated with it.

CREATE TABLE t1 IN DICTIONARY (c1 int, c2 int) 
CREATE INDEX idx_1 IN DICTIONARY on t1(c1) 
DROP INDEX t1.idx_1 IN DICTIONARY 

See Also

CREATE INDEX