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
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. |
|
Examples
Delete english dictionary.
1
|
DROP TEXT SEARCH DICTIONARY english; |
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.