Previous Topic: Define SQL Server CertificatesNext Topic: SQL Server Partitions


Define SQL Server Full-Text Catalogs

Use the SQL Server Fulltext Catalog Editor to define a full-text catalog to properly store your full-text indexes in a SQL Server 2008, 2012, 2014, or 2016 physical model.

To define a SQL Server full-text catalog

  1. Click Target - SQL Server, Fulltext Catalogs on the Model menu.

    The SQL Server Fulltext Catalog Editor opens.

  2. Select the full-text catalog in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new full-text catalog. Use the Enter filter text box to filter a very large list of full-text catalogs to quickly locate the one that you want to define.

    Name

    Displays the full-text catalog name. You can change the full-text catalog name in this field.

    Authorization

    Specifies the owner of the full-text catalog to the name of a database user or role. Select a name from the drop-down list.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. Click the General tab and work with the following options:
    Is Default

    Specifies whether the full-text catalog is the default catalog. This is the full-text catalog used if full-text indexes are created without a full-text catalog explicitly specified.

    Accent Sensitivity

    Specifies if the full-text catalog is accent sensitive or accent insensitive to diacritics for full-text indexing. Select True to specify that the full-text catalog is accent sensitive. Select False to specify that the full-text catalog is accent insensitive.

    File Path

    Specifies the complete file path for the selected full-text catalog.

  4. Click the Permission tab to define the permissions for the full-text catalog.
  5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  6. (Optional) Click the UDP tab to work with user-defined properties for the object.
  7. (Optional) Click the Notes tab to view and edit user notes.
  8. Click Close.

    The full-text catalog is defined and the SQL Server Fulltext Catalog Editor closes.

More information:

Define Permissions for an Object in a SQL Server Property Editor

Add a Comment in a Property Editor

Add a UDP in a SQL Server Physical Property Editor