Specifies whether or not a particular column of a table participates in full-text indexing.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER FULLTEXT INDEX instead.
If the full-text index is active, any ongoing population is stopped. Furthermore, if a table with an active full-text index has change tracking enabled, SQL Server ensures that the index is current. For example, SQL Server stops any current population on the table, drops the existing index, and starts a new population.
If change tracking is on and columns need to be added or dropped from the full-text index while preserving the index, the table should be deactivated, and the required columns should be added or dropped. These actions freeze the index. The table can be activated later when starting a population is practical.
The following example adds the DocumentSummary column from the Document table to the full-text index of the table.
USE AdventureWorks; GO EXEC sp_fulltext_column 'Production.Document', DocumentSummary, 'add'; GO
The following example assumes you created a full-text index on a table named spanishTbl. To add the spanishCol column to the full-text index, execute the following stored procedure:
EXEC sp_fulltext_column 'spanishTbl', 'spanishCol', 'add', 0xC0A; GO
When you run this query:
SELECT * FROM spanishTbl WHERE CONTAINS(spanishCol, 'formsof(inflectional, trabajar)')
The result set would include rows with different forms of trabajar (to work), such as trabajo, trabajamos, and trabajan.
All columns listed in a single full-text query function clause must use the same language.