DROP FULLTEXT CATALOG (Transact-SQL)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2008) ![yes](media/yes.png)Azure SQL Database ![no](media/no.png)Azure SQL Data Warehouse ![no](media/no.png)Parallel Data Warehouse

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

Syntax

  
DROP FULLTEXT CATALOG catalog_name

Arguments

catalog_name
Is the name of the catalog to be removed. If catalog_name does not exist, Microsoft 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.

Permissions

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

See Also

sys.fulltext_catalogs (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
Full-Text Search