drop-fulltext-index-transact-sql.md

title	DROP FULLTEXT INDEX (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	DROP_FULLTEXT_INDEX_TSQL DROP FULLTEXT INDEX
dev_langs	TSQL
helpviewer_keywords	deleting full-text indexes removing full-text indexes full-text indexes [SQL Server], removing DROP FULLTEXT INDEX statement dropping full-text indexes
ms.assetid	7443a4ab-1d43-4a22-bbba-a07f620892cb
author	CarlRabeler
ms.author	carlrab

DROP FULLTEXT INDEX (Transact-SQL)

[!INCLUDE SQL Server SQL Database]

Removes a full-text index from a specified table or indexed view.

Transact-SQL Syntax Conventions

Syntax

  
DROP FULLTEXT INDEX ON table_name  

Arguments

table_name
Is the name of the table or indexed view containing the full-text index to be removed.

Remarks

You do not need to drop all columns from the full-text index before using the DROP FULLTEXT INDEX command.

Permissions

The user must have ALTER permission on the table or indexed view, or be a member of the sysadmin fixed server role, or db_owner or db_ddladmin fixed database roles.

Examples

The following example drops the full-text index that exists on the JobCandidate table.

USE AdventureWorks2012;  
GO  
DROP FULLTEXT INDEX ON HumanResources.JobCandidate;  
GO  

See Also

sys.fulltext_indexes (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
Full-Text Search