Full-text catalogs

A full-text catalog is a logical container that groups one or more full-text indexes and helps organize and manage full-text search indexes on tables.

Database Explorer allows you to perform operations on full-text catalogs using the shortcut menu. Right-click a full-text catalog in Database Explorer to access options for specific tasks, such as generating a CREATE script or duplicating an object.

Create a full-text catalog

1. On the SQL toolbar, click New SQL.

2. In a SQL document, enter the CREATE FULLTEXT CATALOG statement.

CREATE FULLTEXT CATALOG fulltext_catalog_name AS DEFAULT;  
GO

where fulltext_catalog_name is the name of the full-text catalog you want to create.

3. On the SQL toolbar, click Execute, or press F5.

Delete a full-text catalog

1. In Database Explorer, right-click the full-text catalog you want to delete and select Delete, or press Delete.

2. Click Yes to confirm the deletion.

Note

You cannot undo the drop operation, as this action permanently deletes all its data and structure. It is recommended that you back up the database before deleting it.

Duplicate a full-text catalog

1. In Database Explorer, right-click a required full-text catalog and select Duplicate Object.

2. In the Duplicate Object dialog, configure the object settings:

• In Destination connection, select the target server.
• In Destination database, select the target database.
• In Destination schema, select the target schema.
• In New object name, specify the object name.
• Select Drop destination object to drop the destination object if it already exists.
• Optional: Select Script Changes, then select To New SQL Window to generate a script in a new SQL document, or To Clipboard to copy the script to the clipboard.

3. Click OK.

Generate a script for a full-text catalog

1. In Database Explorer, right-click a required full-text catalog and select Generate Script As, then select the statement type.

2. Select the output option:

• To New SQL Window – Opens the script in a new SQL document.
• To File – Generates the script to a .sql file.
• To Clipboard – Copies the script to the clipboard.

For more information, see Generate the DDL and DML statements for database objects.

View properties of a full-text catalog

To view properties of a full-text catalog, in Database Explorer, right-click the full-text catalog or Full-Text Catalogs node and select Show Details.

Object Viewer opens, displaying information about the full-text catalog.

Refresh full-text catalogs

To update the full-text catalog to reflect the latest changes, in Database Explorer, right-click the full-text catalog or Full-Text Catalogs node and select Refresh, or press F5.

Open the Properties window

To open the Properties window, in Database Explorer, right-click the full-text catalog and select Properties, or press F4.

Filter full-text catalogs

1. In Database Explorer, right-click the Full-Text Catalogs node and select Filter.

2. In the Filter Settings dialog, configure the filter parameters.

3. Click OK to apply the filter.

Note

When you open the Full-Text Catalogs node, the number of objects it contains appears in parentheses next to the node name. This number changes based on your filter settings.

Shortcut menu options for a specific full-text catalog

The following table describes the shortcut menu options, which appear when you right-click a specific full-text catalog in Database Explorer.

Shortcut menu options for the Full-Text Catalogs node

The following table describes the shortcut menu options, which appear when you right-click the Full-Text Catalogs node in Database Explorer.

Note

The Source Control shortcut menu is available only after you link the corresponding database to a source-control system.

Bulk operations

In Database Explorer, hold down Ctrl and select multiple full-text catalogs. Then right-click the selection and select the required option.

The following table describes the shortcut menu options available for multiple full-text catalogs.