Full-Text Catalog Properties (Tables/Views Page)
Use this dialog page to view or modify the tables and views that are assigned to the full-text catalog.
Displays all the columns that are full-text indexed. Select a check box to add a column to the full-text index.
Language for Word Breaker
Displays the language of the word breaker.
Data Type Column
Lists the name of the column in the table that holds the document type of the column listed in Available Columns if the column is a varbinary(max) or image column.
The full-text index is automatically updated when the data in the underlying table is modified, added, or deleted.
When data is modified, added, or deleted in the indexed data, SQL Server tracks the changes. When Manual change tracking is in effect, the index is not automatically updated with these changes. Instead, an administrator can apply the changes manually by using an ALTER FULLTEXT INDEX ... START UPDATE POPULATION statement.
Do not track change
With this option in effect, changes to the indexed data in the catalog are not recorded. An administrator must build the index by using ALTER FULLTEXT INDEX with either FULL POPULATION or INCREMENTAL POPULATION.