How to: Start the Full-Text Indexing Wizard (SQL Server Management Studio)

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. It is best to choose a column with small values rather than a column with large ones. One way to create a full-text index is by using the Full-Text Indexing Wizard in Management Studio. 


Another way to create a full-text index in Management Studio is by using Table Designer. For more information, see How to: Create Full-Text Indexes (Visual Database Tools).

To start the Full-Text Indexing wizard

  • In Object Explorer, right-click the table on which you want to create a full-text index, point to Full-Text index, and then click Define Full-Text Index.

    For information about the dialog boxes of the Full-Text Indexing Wizard, use the respective F1 help screens.