Full-text Indexes

Go Up to Supported Objects

A full-text index stores information used by the Full-Text Engine to compile full-text queries that can quickly search a table for particular words or word combinations. A full-text index stores information about key words and their location within one or more columns of a table.

Full-text indexes, along with full-text catalogs and the object actions supported for these object types, provide full text search support.

Note: Before working with full-text indexes, consult Microsoft SQL Server documentation for a general understanding of full-text searching. For more information, see Accessing Third Party Documentation.

Creating and editing

• Full-text Indexes Wizard (SQL Server) and Full-text Indexes Editor (SQL Server)

DBMS platform availability and object actions/operations supported

The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.

	SQL SVR
Change Status (Full-text Indexes)	✓
Drop	✓
Extract	✓
Migrate	✓
Population status	✓
Report	✓

Related information

• Full-text Catalogs