drop-fulltext-catalog-transact-sql.md

title	DROP FULLTEXT CATALOG (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.suite	sql
ms.technology	t-sql
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP_FULLTEXT_CATALOG_TSQL DROP FULLTEXT CATALOG
dev_langs	TSQL
helpviewer_keywords	dropping full-text catalogs removing full-text catalogs full-text catalogs [SQL Server], removing deleting full-text catalogs DROP FULLTEXT CATALOG statement
ms.assetid	b54efb0b-400b-49ce-923b-ce20a2a12255
caps.latest.revision	21
author	CarlRabeler
ms.author	carlrab
manager	craigg

DROP FULLTEXT CATALOG (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

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

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, [!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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