Full-Text Catalogs (SQL Server)

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 Catalogs to access the List of Full Text Catalogs, and click the Add a Row tool.

  • Right-click the model (or a 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 Catalogs 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