DROP FULLTEXT INDEX (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Topic link icon Transact-SQL Syntax Conventions

  
DROP FULLTEXT INDEX ON table_name  

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

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

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.

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

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

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

Community Additions

ADD
Show: