Help Center > > Developer Guide> SQL Reference> SQL Syntax> DROP TEXT SEARCH DICTIONARY

DROP TEXT SEARCH DICTIONARY

Updated at: Mar 13, 2020 GMT+08:00

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

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

1
2
-- Delete the english dictionary.
DROP TEXT SEARCH DICTIONARY english;

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel