Dropping a Text Configuration Using Interactive SQL

Remove an unnecessary text configuration from the database.

Only text configurations that are not being used by a TEXT index can be dropped.

  1. Connect to the database as a user with DBA or RESOURCE authority.
  2. Execute a DROP TEXT CONFIGURATION statement.

To drop the text configuration object myTxtConfig:

DROP TEXT CONFIGURATION myTxtConfig;