Export (0) Print
Expand All
Expand Minimize

DROP FULLTEXT INDEX (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Community Additions

ADD
Show:
© 2015 Microsoft