Udostępnij za pośrednictwem


DROP FULLTEXT STOPLIST (Transact-SQL)

Drops a full-text stoplist from the database.

Ikona łącza do tematu Transact-SQL Syntax Conventions

Ważna informacjaWażne:

CREATE FULLTEXT STOPLIST is supported only for compatibility level 100. For compatibility levels 80 and 90, the system stoplist is always assigned to the database.

Składnia

DROP FULLTEXT STOPLIST stoplist_name
;

Arguments

  • stoplist_name
    Is the name of the full-text stoplist to drop from the database.

Uwagi

DROP FULLTEXT STOPLIST fails if any full-text indexes refer to the full-text stoplist being dropped.

Permissions

To drop a stoplist requires having DROP permission on the stoplist or membership in the db_owner or db_ddladmin fixed database roles.

Examples

The following example drops a full-text stoplist named myStoplist.

DROP FULLTEXT STOPLIST myStoplist;

Zobacz także

Odwołanie

ALTER FULLTEXT STOPLIST (Transact-SQL)

CREATE FULLTEXT STOPLIST (Transact-SQL)

sys.fulltext_stoplists (Transact-SQL)

sys.fulltext_stopwords (Transact-SQL)