Modifying a Full-Text Index : FULLTEXT « Data Types « SQL Server / T-SQL Tutorial






ALTER FULLTEXT INDEX ON MyDocument
ADD (Title)

ALTER FULLTEXT INDEX ON MyDocument
START FULL POPULATION

ALTER FULLTEXT INDEX ON MyDocument
SET CHANGE_TRACKING OFF

ALTER FULLTEXT INDEX ON MyDocument
DROP (Title)








5.12.FULLTEXT
5.12.1.Creating a Full-Text Catalog
5.12.2.Creating a Full-Text Catalog and specify the path
5.12.3.Retrieving Full-Text Catalog and Index Metadata
5.12.4.Using FREETEXT to Search Full-Text Indexed Columns
5.12.5.Creating a Full-Text Index
5.12.6.Modifying a Full-Text Index
5.12.7.Dropping a Full-Text Catalog
5.12.8.Dropping a Full-Text Index