DROP INDEX
This statement drops a specific index from a designated table.
Syntax
DROP INDEX
[
table-name
. ]
index-name
[
IN DICTIONARY
]
table-name
::=
user-defined-name
index-name
::=
user-defined-name
Remarks
IN DICTIONARY is a very powerful and advanced feature. It should only be used by system administrators or when absolutely necessary. The IN DICTIONARY keyword allows you to drop an index from a DDF without removing the index from the underlying data file. Normally, Pervasive PSQL 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
.
Partial Indexes
When dropping partial indexes, the PARTIAL modifier is not required.
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
Caution: Modifying a DDF without performing parallel modifications to the underlying data file can cause serious problems.