Dropping a TEXT index

Drop TEXT indexes from the database.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. In the left pane, select the Text Indexes folder.

3. In the list of Text Indexes, right-click the object to modify and select Delete.

4. In the confirmation dialog, click Yes.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. Execute a DROP TEXT INDEX statement.

   For example, to drop the MyTextIndex TEXT index, enter:

   DROP TEXT INDEX MyTextIndex ON Customers;