Table Properties, Full-Text Indexing Tab

Full-Text Search Help

Full-Text Search Help

Table Properties, Full-Text Indexing Tab

This section shows the options and their functions available on the Full-Text Indexing tab of the Table Properties dialog box.

Full-text index status

Indicates whether the full-text index for this table is active or inactive. An active full-text index supports full-text queries.

Full-text catalog

Displays the name of the full-text catalog containing the full-text index for this table. You can find this full-text catalog in the Full-Text Catalog folder of this table's database.

Full-text unique key column

Displays the column name of the unique key used to identify table rows in the full-text index.

Full-text unique key index

Displays the index of the unique key used to identify table rows in the full-text index.

Full-text change-tracking

Indicates whether full-text change-tracking is enabled for this table.

Full-text update-index

Indicates whether full-text update-index is enabled for this table.

Columns

Displays the columns of this table. Textual columns selected to participate in full-text indexing are checked.