DROP TEXT INDEX

Drops a text index used to perform text searches.

Syntax

DROP TEXT INDEX [ IF EXISTS ] [schema.]idx‑table

Parameters

[IF EXISTS]
If specified, DROP TEXT INDEX does not report an error if one or more of the tables to be dropped does not exist. You can use this clause in SQL scripts where you want to drop a table, if it exists, before recreating it.
schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
idx‑table
Specifies the text index name. When using more than one schema, specify the schema that contains the index in the DROP TEXT INDEX statement.

Privileges

Table owner and dbadmin with USAGE privilege on schema that contains the table or schema owner.

Behavior

When a source table is dropped that has a text index associated with it, the text index is also dropped.

Examples

The following example drops the text index t_text_index:

=> DROP TEXT INDEX t_text_index;
DROP INDEX

See Also