DROP TEXT INDEX
Removes
a text index from a column in a table.
SYNTAX
| text_index_name |
Name
of the text index you want to remove. |
| table_name |
Name
of the table you want to remove the text index from. |
DESCRIPTION
The DROP
TEXT INDEX command removes an existing text index on a column in a table
from the database. To execute the DROP TEXT INDEX command to drop a text
index from a table, you must be the table owner, have DBA or SYSADM security
privileges, or have the INDEX privilege for that table.
A text index
is a mechanism that provides fast access to rows in a table that contain
one or more words or phrases in columns containing text. Text indexes
contain a representation of all the text found in the text columns they
are based on, but the data is encoded and structured to make retrieval
much faster than directly from the table. Once you create a text index
on a table, its operation is transparent to users of the database; the
DBMS will use the index to improve full-text query performance whenever
possible.
EXAMPLE
The following
example drops the text index named TxtIdx from the Employees table.
DROP TEXT INDEX TxtIdx FROM Employees
|
RELATED COMMANDS
<
DROP TABLESPACE | Contents
| DROP TRIGGER >
|
