Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DROP FULLTEXT CATALOG (Transact-SQL)
Collapse the table of content
Expand the table of content

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