Full-text Indexes Wizard (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Wizards

This wizard lets you build and submit a CREATE FULLTEXT INDEX statement, adding a full-text index for a table or indexed view. Along with full-text catalogs, full-text indexes facilitate full-text searching.

Note: Full-text indexes cannot be created in the master catalog.
Note: Before working with full-text indexes, consult Microsoft SQL Server documentation for general information on full-text searching and detailed information on topics such as required permissions, column specification details, recommended datatype, and XML considerations. For more information, see Accessing Third Party Documentation.

To create a new full-text index using a wizard:

  1. Open a creation wizard for a full-text index. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Full-text Indexes (SQL Server) - Properties

When creating or editing a full-text index, this tab/panel lets you work with the following settings:

Setting Description

Parent Type

Select table or indexed view.

Parent Schema

The parent’s owning schema.

Parent Name

Select the name of the table or indexed view on which the index is to be created.

Key Index

Select the unique key index on the table or view that will be used as the value for the KEY INDEX argument.

Full-text Catalog Name

Select an existing full-text catalog. For information on creating full-text catalogs, see Full-text Catalogs Wizard (SQL Server). If you do not select a catalog, SQL Server will assign the index to the default full-text catalog, generating an error if no default exists.

Filegroup Name (SQL Server 2008 ^)

Select the filegroup that the index is to be created on. Specifying no filegroup results in SQL Server default behavior, placing the index in the same filegroup as the base table or view for a non-partitioned table or in the PRIMARY filegroup for a partitioned table.

Change Tracking

Select a CHANGE_TRACKING argument value of MANUAL, AUTO, OFF, or OFF, NO POPULATION to specify whether changes to columns covered by the full-text index will be propagated to the full-text index.

Stoplist (SQL Server 2008 ^)

Select a STOPLIST argument value of OFF to specify that no stoplist be associated with the index or SYSTEM to specify that the default full-text system STOPLIST be used for this index.

Full-text Indexes (SQL Server) - Columns

When creating or editing a full-text index, this tab/panel lets you specify the columns that make up the index:

  • For each column to include in the full-text index, select the associated Indexed check box.
  • Optionally, select a language from the associated Language column.
  • For varbinary(max) and image columns, provide a TYPE COLUMN argument filename extension.