Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

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. 

NoteNote

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.