Help Center/ Data Warehouse Service / SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ DROP TEXT SEARCH DICTIONARY
Updated on 2025-09-18 GMT+08:00
View PDF

DROP TEXT SEARCH DICTIONARY

Function

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

Precautions

  • 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.

Syntax

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

Parameter Description

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.

Examples

Delete english dictionary.

1
 
DROP TEXT SEARCH DICTIONARY english;

Helpful Links

ALTER TEXT SEARCH DICTIONARY, CREATE TEXT SEARCH DICTIONARY

Parent Topic: DDL Syntax