Chapter 15 DBMS-Specific Features
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".
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 | Scripting Name | Description |
---|---|---|
Catalog | FullTextCatalog | Specifies the full text catalog where the full text index is defined. |
Change tracking | ChangeTracking | Specifies whether or not SQL Server maintains a list of all changes to the indexed data. You can choose between:
|
Copyright (C) 2006. Sybase Inc. All rights reserved. |
![]() |