Removes a text index from the database.
DROP TEXT INDEX text-index-name ON [ owner.]table-name
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.
SQL/2003 Vendor extension.
The following statement creates a text index, TextIdx, and then drops it:
CREATE TEXT INDEX TextIdx ON MarketingInformation ( Description ) DROP TEXT INDEX TextIdx ON MarketingInformation;
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|