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
Expand Minimize

DROP FULLTEXT INDEX (Transact-SQL)

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 AdventureWorks;
GO
DROP FULLTEXT INDEX ON HumanResources.JobCandidate;
GO

Community Additions

ADD
Show:
© 2015 Microsoft