HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

DROP TEXT SEARCH DICTIONARY

Function

DROP TEXT SEARCH DICTIONARY deletes a full-text retrieval dictionary.

Precautions

  • Predefined dictionaries do not support the DROP operations.
  • 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

DropTextSearchDictionary ::= 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 of the dictionary to be deleted. (If you do not specify a schema name, the dictionary in the current schema will be used.)

    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

-- Delete the english dictionary.
MogDB=# DROP TEXT SEARCH DICTIONARY english;

ALTER TEXT SEARCH DICTIONARY and CREATE TEXT SEARCH DICTIONARY

Copyright © 2011-2024 www.enmotech.com All rights reserved.