Export (0) Print
Expand All
Expand Minimize

Full-Text Index Dialog Box 

Create a full-text index if you want to perform full-text searches on text-based columns in your database tables. A full-text index relies on a regular index, so you will need to create that first. The regular index must be created on a single, non-null column, and it is best to choose a column with small values rather than a column with large ones. For more information, see How to: Create Indexes.

NoteNote

To create a full-text index, you must first create a full-text catalog for the database using an outside tool, such as SQL Workbench or Enterprise Manager.

NoteNote

Full-text index functionality is not available in Microsoft SQL Server Express 2005.

NoteNote

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

Selected Full-Text Index

Lists existing full-text indexes. Select an index to show its properties in the grid to the right. If the list is empty, no full-text relationships have been defined for the table.

Add Button

Creates a new full-text index.

Delete Button

Deletes the full-text index selected in the Selected Full-Text Index list.

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.

NoteNote

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

Working with Indexes

Community Additions

ADD
Show:
© 2014 Microsoft