Dropping a TEXT Index Using Interactive SQL

Drop a TEXT index from the database.

1. Connect to the database as a user with DBA or RESOURCE authority.
2. Execute a DROP TEXT INDEX statement.

DROP TEXT INDEX MyTextIndex ON Customers;