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

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: Database and schema. The default schema is public. 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.

=> DROP TEXT INDEX t_text_index;
DROP INDEX