Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DROP FULLTEXT INDEX (Transact-SQL)

 

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

Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12.

Topic link iconTransact-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
Show:
© 2015 Microsoft