DROP FULLTEXT INDEX (Transact-SQL)
Removes a full-text index from a specified table.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
DROP FULLTEXT INDEX ON table_name
Arguments
- table_name
Is the name of the table 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 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 AdventureWorks;
GO
DROP FULLTEXT INDEX ON HumanResources.JobCandidate;
GO
See Also
Reference
ALTER FULLTEXT INDEX (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)