DROP TEXT INDEX

Drops a text index used to perform text searches.

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

Syntax

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

Parameters

IF EXISTS

Specifies not to report an error if the text index to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.

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

  • dbadmin
  • Table owner
  • DROP privileges on the source table

Examples

=> DROP TEXT INDEX t_text_index;
DROP INDEX

See Also