DROP TEXT SEARCH DICTIONARY
Function
DROP TEXT SEARCH DICTIONARY deletes a full-text retrieval dictionary.
Precautions
- Predefined dictionaries do not support the DROP operation.
- Only the owner of a dictionary or a system administrator has the DROP TEXT SEARCH DICTIONARY permission.
- Execute DROP...CASCADE only when necessary because this operation will delete the text search configurations that use this dictionary.
Syntax
DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ]
Parameter Description
- IF EXISTS
Reports a notice instead of an error if the specified full-text retrieval dictionary does not exist.
- name
Specifies the name (optionally schema-qualified) of the full-text retrieval dictionary to be deleted. (If you do not specify a schema name, the dictionary will be deleted in the current schema by default.)
Value range: an existing dictionary name
- CASCADE
Automatically deletes the objects that depend on the full-text retrieval dictionary and other objects that depend on these objects.
If any text search configuration uses the dictionary, the DROP statement will fail. You can add CASCADE to delete all text search configurations and dictionaries that use this dictionary.
- RESTRICT
Refuses to delete the full-text retrieval dictionary if any object depends on it. This is the default action.
Examples
1 2 |
-- Delete the english dictionary. DROP TEXT SEARCH DICTIONARY english; |
Helpful Links
ALTER TEXT SEARCH DICTIONARY and CREATE TEXT SEARCH DICTIONARY
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot