Full-text catalogs

Chapter 15 DBMS-Specific Features

Full-text catalogs

A full-text catalog contains zero or more full-text indexes. PowerDesigner models full-text catalogs as extended objects with a stereotype of <<FullTextCatalog>>.

Creating a full-text catalog

You can create a full-text catalog in any of the following ways:

Select Model→Full-Text Catalog Objects to access the List of Full-Text Catalogs, and click the Add a Row tool
Right-click the model or package in the Browser, and select New→Full-Text Catalog

Full-text catalog properties

You can modify an object's properties from its property sheet. To open a full-text catalog property sheet, double-click its diagram symbol or its Browser entry in the Full-Text Catalog Objects folder.

The following extended attributes are available on the Microsoft tab:

Name	Description
Authorization	Specifies the name of a user or role as the owner of the full text catalog. Scripting name: Authorization
File group	Specifies the name of the SQL Server filegroup (or storage) of which the new catalog will be part. Scripting name: FileGroup
Path	Specifies the root directory for the catalog. Scripting name: Path
Accent sensitivity	Specifies whether the catalog is accent sensitive for full text indexing. Scripting name: AccentSensitivity
Default	Specifies that the catalog is the default catalog. Scripting name: Default