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

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 Overview.

To create full-text indexes

  1. In Object Explorer, right-click the table for which you want to create a full-text index and click Design.

    The table opens in Table Designer.

  2. From the Table Designer menu, click Full-Text 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).