Export (0) Print
Expand All
Expand Minimize

DROP FULLTEXT CATALOG (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Removes a full-text catalog from a database. You must drop all full-text indexes associated with the catalog before you drop the catalog.

Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.

Topic link icon Transact-SQL Syntax Conventions

DROP FULLTEXT CATALOG catalog_name

catalog_name

Is the name of the catalog to be removed. If catalog_name does not exist, Microsoft SQL Server returns an error and does not perform the DROP operation. The filegroup of the full-text catalog must not be marked OFFLINE or READONLY for the command to succeed.

User must have DROP permission on the full-text catalog or be a member of the db_owner, or db_ddladmin fixed database roles.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft