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