DROP TEXT SEARCH DICTIONARY

DROP TEXT SEARCH DICTIONARY deletes a full-text retrieval dictionary.

DROP is not supported by predefined dictionaries.
Only the owner of a dictionary can do DROP to the dictionary. System administrators have this permission by default.
Execute DROP...CASCADE only when necessary because this operation will delete the text search configuration that uses this dictionary.

 DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ]
 

**Table 1** DROP TEXT TEXT SEARCH DICTIONARY parameters
Parameter	Description	Value Range
IF EXISTS	Sends a notice instead of an error if the specified full-text search dictionary does not exist.	-
name	Specifies the name of a dictionary to be deleted. (If you do not specify a schema name, the dictionary in the current schema will be deleted by default.)	Name of an existing dictionary.
CASCADE \| RESTRICT	Specifies how to process related data in the dependent object when a delete operation is performed.	CASCADE: Automatically deletes dependent objects of a dictionary and then deletes all dependent objects of these objects in sequence. If any text search configuration that uses the dictionary exists, DROP execution will fail. You can add CASCADE to delete all text search configurations and dictionaries that use the dictionary. RESTRICT: Rejects the deletion of a dictionary if any object depends on the dictionary. This is the default.

Delete english dictionary.

 DROP TEXT SEARCH DICTIONARY english;
 

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.