DROP FULLTEXT INDEX (Transact-SQL)
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
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
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.
USE AdventureWorks2022;
GO
DROP FULLTEXT INDEX ON HumanResources.JobCandidate;
GO
See Also
sys.fulltext_indexes (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
Full-Text Search
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort beschikbaar: In de loop van 2024 zullen we GitHub-problemen geleidelijk uitfaseren als het feedbackmechanisme voor inhoud en deze vervangen door een nieuw feedbacksysteem. Zie voor meer informatie:Feedback verzenden en weergeven voor