Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Database Engine
Transact-SQL Reference (Database Engine)
Data Definition Language (DDL) Statements (Transact-SQL)
DROP Statements (Transact-SQL)
DROP AGGREGATE (Transact-SQL)
DROP APPLICATION ROLE (Transact-SQL)
DROP ASSEMBLY (Transact-SQL)
DROP ASYMMETRIC KEY (Transact-SQL)
DROP AVAILABILITY GROUP (Transact-SQL)
DROP BROKER PRIORITY (Transact-SQL)
DROP CERTIFICATE (Transact-SQL)
DROP CONTRACT (Transact-SQL)
DROP CREDENTIAL (Transact-SQL)
DROP CRYPTOGRAPHIC PROVIDER (Transact-SQL)
DROP DATABASE (Transact-SQL)
DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)
DROP DATABASE ENCRYPTION KEY (Transact-SQL)
DROP DEFAULT (Transact-SQL)
DROP ENDPOINT (Transact-SQL)
DROP EVENT NOTIFICATION (Transact-SQL)
DROP EVENT SESSION (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
DROP FULLTEXT STOPLIST (Transact-SQL)
DROP FUNCTION (Transact-SQL)
DROP INDEX (Transact-SQL)
DROP LOGIN (Transact-SQL)
DROP MASTER KEY (Transact-SQL)
DROP MESSAGE TYPE (Transact-SQL)
DROP PARTITION FUNCTION (Transact-SQL)
DROP PARTITION SCHEME (Transact-SQL)
DROP PROCEDURE (Transact-SQL)
DROP QUEUE (Transact-SQL)
DROP REMOTE SERVICE BINDING (Transact-SQL)
DROP RESOURCE POOL (Transact-SQL)
DROP ROLE (Transact-SQL)
DROP ROUTE (Transact-SQL)
DROP RULE (Transact-SQL)
DROP SCHEMA (Transact-SQL)
DROP SEARCH PROPERTY LIST (Transact-SQL)
DROP SEQUENCE (Transact-SQL)
DROP SERVER AUDIT (Transact-SQL)
DROP SERVER AUDIT SPECIFICATION (Transact-SQL)
DROP SERVER ROLE (Transact-SQL)
DROP SERVICE (Transact-SQL)
DROP SIGNATURE (Transact-SQL)
DROP STATISTICS (Transact-SQL)
DROP SYMMETRIC KEY (Transact-SQL)
DROP SYNONYM (Transact-SQL)
DROP TABLE (Transact-SQL)
DROP TRIGGER (Transact-SQL)
DROP TYPE (Transact-SQL)
DROP USER (Transact-SQL)
DROP VIEW (Transact-SQL)
DROP WORKLOAD GROUP (Transact-SQL)
DROP XML SCHEMA COLLECTION (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

DROP FULLTEXT STOPLIST (Transact-SQL)

SQL Server 2012

Drops a full-text stoplist from the database.

Topic link icon Transact-SQL Syntax Conventions

Important note Important

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.
Copy 
DROP FULLTEXT STOPLIST stoplist_name
;
stoplist_name

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

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

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

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

Copy 
DROP FULLTEXT STOPLIST myStoplist;
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.