Drops a text configuration object.
DROP TEXT CONFIGURATION [ owner.]text-config-name
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 View text indexes in the database.
Must be the owner of the text configuration object or have DBA authority.
Automatic commit
SQL/2003 Vendor extension.
The following statements create and drop the mytextconfig text configuration object:
CREATE TEXT CONFIGURATION mytextconfig FROM default_char; DROP TEXT CONFIGURATION mytextconfig; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |