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
- dbadmin
- Table owner
- DROP privileges on the source table
Examples
=> DROP TEXT INDEX t_text_index; DROP INDEX