Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Removes a full-text index from a specified table or indexed view.
Transact-SQL syntax conventions
Syntax
DROP FULLTEXT INDEX ON table_name
Arguments
table_name
Is the name of the table or indexed view containing the full-text index to be removed.
Remarks
You do not need to drop all columns from the full-text index before using the DROP FULLTEXT INDEX command.
Permissions
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.
Examples
The following example drops the full-text index that exists on the JobCandidate table.
Note
In Azure SQL Database and SQL database in Microsoft Fabric, the USE statement isn't available. Instead, connect directly to intended database and run the rest of the code sample.
USE AdventureWorks2022;
GO
DROP FULLTEXT INDEX ON HumanResources.JobCandidate;
GO
