Help Center > > Developer Guide> SQL Reference> SQL Syntax> DROP TEXT SEARCH CONFIGURATION

DROP TEXT SEARCH CONFIGURATION

Updated at: May 15, 2019 GMT+08:00

Function

DROP TEXT SEARCH CONFIGURATION deletes an existing text search configuration.

Precautions

Only the owner of the configuration can run this command.

Syntax

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

Parameter Description

  • IF EXISTS

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

  • name

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

  • CASCADE

    Automatically deletes objects that depend on the text search configuration to be deleted.

  • RESTRICT

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

Examples

See Examples in CREATE TEXT SEARCH CONFIGURATION.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel