Full-text Indexes

A full-text index stores information about significant words and their location within a given column. This information is used to quickly compute full-text queries that search for rows with particular words or combinations of words. PowerDesigner models full-text indexes as table indexes with an index type set to "Full Text".

Full-text Index Properties

You can modify an object's properties from its property sheet. To open a full-text index property sheet, double-click its Browser entry.

In addition to the standard index properties, a full-text index has the following additional properties available on the Microsoft tab:

Name	Description
Catalog	Specifies the full text catalog where the full text index is defined. Scripting name: FullTextCatalog
Change tracking	Specifies whether or not SQL Server maintains a list of all changes to the indexed data. You can choose between: manual auto off off, no population Scripting name: ChangeTracking

Name

Description

Catalog

Specifies the full text catalog where the full text index is defined.

Scripting name: FullTextCatalog

Change tracking

Specifies whether or not SQL Server maintains a list of all changes to the indexed data. You can choose between:

manual
auto
off
off, no population

Scripting name: ChangeTracking