DROP FULLTEXT DICTIONARY

Name

DROP FULLTEXT DICTIONARY -- remove a full-text dictionary

Synopsis

DROP FULLTEXT DICTIONARY [IF EXISTS]dictname [ CASCADE | RESTRICT ];
  

Description

DROP FULLTEXT DICTIONARY removes full-text dictionary from the database. Only its owner may destroy a configuration.

To drop a dictionary and all FTS objects, which depends on it, CASCADE must be specified.

Parameters

IF EXISTS

Do not throw an error if the dictionary does not exist. A notice is issued in this case.

dictname

The name (optionally schema-qualified) of the dictionary to drop.

CASCADE

Automatically drop FTS objects that depend on the dictionary.

RESTRICT

Refuse to drop the dictionary if any objects depend on it. This is the default.

See Also

CREATE FULLTEXT DICTIONARY