Full-text Index Properties

There are two sets of Full-text Index properties: you can select the object in server explorer to see an abbreviated set or select the object from the dropdown list at the top of the Properties window to see a fuller set.

Note

These properties apply only to Microsoft SQL Server.

Note

The properties in this topic are ordered by category rather than alphabet.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

Properties for object selected in Server Explorer

  • Identity Category
    Expands to show the Name property.

  • Name
    Displays the name of this index.

  • Misc Category
    Expands to show the Is Active property.

  • Is Active
    Indicates whether the index is active (True) or disabled (False).

Properties for object selected from the Properties window dropdown

  • General Category
    Expanded, shows Columns and Full-text Catalog Name.

  • Columns
    Displays a comma-separated list of the names of full-text-searchable columns. To see the complete list, click the ellipsis (…) to the left of the property field.

  • Full-Text Catalog Name
    Displays the name of the full-text catalog on which this full-text index is stored. To store the index on a different catalog, click the catalog name and choose another from the drop-down list.

    Note

    The catalog must be created first in an outside tool, such as SQL Workbench or Enterprise Manager.

  • Identity Category
    Expanded, shows the name field for this index.

  • Name
    Displays the system-specified name for this full-text index.

  • Table Designer Category
    Expanded, shows properties that dictate how the index performs.

  • Active
    Shows whether you can currently perform a full-text search using this full-text index.

  • Change Tracking Setting
    Describes the status of change tracking for this index: Manual, Auto, or Off.

  • Crawl Completed
    Shows whether the most recent crawl has been completed. If this property value is No, then a crawl is currently in progress.

  • End Date And Time Of Current Or Last Crawl
    Displays the date and time that the most recent crawl ended.

  • Errors In Current Or Last Crawl
    Displays the number of errors in current or most recent crawl.

  • Index Version
    Displays the schema version of table at time the crawl started.

  • Rows In Current Or Last Crawl
    Displays the number of rows updated in the current or most recent crawl.

  • Start Date And Time Of Current Or Last Crawl
    Displays the date and time that the current or most recent crawl started.

  • Time Stamp For Next Crawl
    Displays the date and time that the next crawl will start.

  • Type Of Current Or Last Crawl
    Displays the type of the current or most recent crawl: Full, Incremental, Update, or Auto Propagation.

  • Unique Index Name
    Displays a list of all of the names of columns in this database that have unique single-column indexes. These columns can be used to create a full-text index.

See Also

Other Resources

Properties in Visual Database Tools

Working with Indexes