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 DROP ANY TEXT CONFIGURATION or DROP ANY OBJECT system privilege.
  2. Execute a DROP TEXT CONFIGURATION statement.

To drop the text configuration object myTxtConfig:

DROP TEXT CONFIGURATION myTxtConfig;