This documentation is archived and is not being maintained.

How to: Create Full-Text Indexes (Visual Database Tools)

Updated: 12 December 2006

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.

To create a full-text index, you must first create a catalog using an external tool such as SQL Server Management Studio.

To allow the index to include the textual data from Microsoft Office files (.doc, .xls, and .ppt files), text files (.txt files), and HTML files (.htm files), store those files in a field with the data type "image." For more information, see Full-Text Search Concepts.

  1. In Object Explorer, right-click the table for which you want to create a full-text index and click Design (Modify in SP1 or earlier).

    The table opens in Table Designer.

  2. From the Table Designer menu, click Fulltext Index.

    The Full-text Index dialog box opens.

  3. Click Add.

  4. Select the new index in the Selected Full-text Index list and set properties for the index in the grid to the right.

For more information on how to choose properties, see Full-Text Index Dialog Box (Visual Database Tools).