Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DROP FULLTEXT CATALOG (Transact-SQL)

 

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 iconTransact-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.

Show:
© 2015 Microsoft