Full-Text Index Dialog Box (Visual Database Tools)
This dialog box allows you to create a full-text index, for full-text searches on text-based columns in your database tables. A full-text index relies on a regular index, so you must create that first. The regular index must be created on a single, non-null column; 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 (Visual Database Tools).
Note
To create a full-text index, you must first create a full-text catalog for the database using an outside tool, such as SQL Server Management Studio or Enterprise Manager.
Note
Full-text index functionality is not available in Microsoft SQL Server Express 2005.
Options
- 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
Create a new full-text index.
- Delete
Delete the full-text index selected in the Selected Full-Text Index list.
- General Category
When 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 button (…) 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 Server Management Studio or Enterprise Manager.
- Identity Category
When expanded, shows the name field for this index.
- Name
Displays the system-specified name for this full-text index.
- Table Designer Category
When expanded, shows properties that dictate how the index performs.
- Active
Indicates 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, 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
Reference
Other Resources
Working with Indexes (Visual Database Tools)
CREATE FULLTEXT INDEX (Transact-SQL)