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 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
Table owner and dbadmin with USAGE privilege on schema that contains the table or schema owner.
Examples
=> DROP TEXT INDEX t_text_index; DROP INDEX