DROP TEXT INDEX
Drops a text index used to perform text searches.
Drops a text index used to perform text searches.
Note
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.]schemaDatabase 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 INDEXstatement.
Privileges
-
dbadmin
-
Table owner
-
DROP privileges on the source table
Examples
=> DROP TEXT INDEX t_text_index;
DROP INDEX