Jaa


How to: Delete Full-Text Indexes from Databases (Visual Database Tools)

Delete a full-text index when it is no longer needed.

To delete a full-text index

  1. In Object Explorer, right-click the table with the full-text index you want to delete 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 the index you want to delete in the Selected Full-text Index column.

  4. Click Delete.

See Also

Tasks

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

Other Resources

Working with Indexes (Visual Database Tools)
Full-Text Index Dialog Box (Visual Database Tools)
Full-Text Search Concepts

Help and Information

Getting SQL Server 2005 Assistance