Updated on 2024-09-02 GMT+08:00

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

  • IF EXISTS

    Reports a notice instead of throwing an error if the specified full-text retrieval 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.)

    Value range: name of an existing dictionary

  • 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 the english dictionary:

1
DROP TEXT SEARCH DICTIONARY english;