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