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