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

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

 

DROP TEXT CONFIGURATION statement

Drops a text configuration object.

Syntax
DROP TEXT CONFIGURATION [ owner.]text-config-name
Remarks

Attempting to drop a text configuration object with dependent text indexes results in an error. You must drop the dependent text indexes before dropping the text configuration object.

Text configuration objects are stored in the ISYSTEXTCONFIG system table.

To determine the text indexes that refer to the text configuration object, see Accessing text index information in the database.

Permissions

Must be the owner of the text configuration object or have DBA authority.

Side effects

Automatic commit

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

Example

The following statement creates a text configuration object, mytextconfig, and then drops it:

CREATE TEXT CONFIGURATION mytextconfig FROM default_char;
DROP TEXT CONFIGURATION mytextconfig;