Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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 AdventureWorks2022;
GO
DROP FULLTEXT INDEX ON HumanResources.JobCandidate;
GO
sys.fulltext_indexes (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
Full-Text Search
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today