DROP TEXT SEARCH CONFIGURATION

Function

DROP TEXT SEARCH CONFIGURATION deletes a text search configuration.

Precautions

Only the owner of a text search configuration has the DROP TEXT SEARCH CONFIGURATION permission.

Syntax

DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ];

Parameter Description

• IF EXISTS

  Reports a notice instead of an error if the specified text search configuration does not exist.

• name

  Specifies the name (optionally schema-qualified) of the text search configuration to be deleted.

• CASCADE

  Automatically deletes the objects that depend on the text search configuration.

• RESTRICT

  Refuses to delete the text search configuration if any objects depend on it. This is the default action.

Examples

See Examples in CREATE TEXT SEARCH CONFIGURATION.

Helpful Links

ALTER TEXT SEARCH CONFIGURATION and CREATE TEXT SEARCH CONFIGURATION