Export (0) Print
Expand All
Expand Minimize

DROP FULLTEXT INDEX (Transact-SQL)

Removes a full-text index from a specified table.

Topic link icon Transact-SQL Syntax Conventions


DROP FULLTEXT INDEX ON table_name

table_name

Is the name of the table 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 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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft