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
Expand Minimize

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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft