Dropping a TEXT Index Using Interactive SQL

Drop a TEXT index from the database.

1. Connect to the database as a user with DROP ANY INDEX or DROP ANY OBJECT system privilege or as the owner of the underlying table.
2. Execute a DROP TEXT INDEX statement.

DROP TEXT INDEX MyTextIndex ON Customers;