Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Removes a text index from the database.
DROP TEXT INDEX text-index-name
ON [ owner.]table-name
Use this clause to specify the table on which the text index was built.
You must drop dependent text indexes before you can drop a text configuration object.
Must be the owner of the underlying table, or have DBA authority, or have REFERENCES permission.
This statement cannot be executed when there are cursors opened with the WITH HOLD clause that use either statement or transaction
snapshots. See Snapshot isolation.
The following statements create and drop the TextIdx text index:
CREATE TEXT INDEX TextIdx ON MarketingInformation ( Description )
DROP TEXT INDEX TextIdx ON MarketingInformation;