Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (A-D)

 

DROP TEXT INDEX statement

Removes a text index from the database.

Syntax
DROP TEXT INDEX text-index-name 
ON [ owner.]table-name
Parameters
  • ON clause   Use this clause to specify the table on which the text index was built.

Remarks

You must drop dependent text indexes before you can drop a text configuration object.

Permissions

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.

Side effects

Automatic commit

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statements create and drop the TextIdx text index:

CREATE TEXT INDEX TextIdx ON MarketingInformation ( Description )
DROP TEXT INDEX TextIdx ON MarketingInformation;