Search property lists

A search property list is a collection of search properties or custom properties that you define to include in a full-text index.

In Database Explorer, you can perform operations on search property lists by using the shortcut menu. Right-click a search property list in Database Explorer to access commands for specific tasks, such as generating a CREATE script or duplicating an object.

Create a search property list

1. On the SQL toolbar, click New SQL.

2. In a SQL document, enter the CREATE SEARCH PROPERTY LIST statement.

CREATE SEARCH PROPERTY LIST new_list_name  
   [ FROM [ database_name. ] source_list_name ]  
   [ AUTHORIZATION owner_name ]  
;

where:

• new_list_name is the name of the search property list you want to create.
• database_name is the database that contains the property list specified by source_list_name. If the database isn’t specified, the current database is used by default.
• source_list_name indicates that the new property list is created by copying an existing one from database_name. If source_list_name doesn’t exist, the CREATE SEARCH PROPERTY LIST statement fails and returns an error. All search properties from source_list_name are copied to new_list_name.
• owner_name specifies the name of a user or role who will own the property list. The value must be a role the current user belongs to, or a user the current user has IMPERSONATE permission for. If not specified, the current user becomes the owner.

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

Delete a search property list

1. In Database Explorer, right-click the search property list 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 the search property list. To avoid data loss, back up the database before deleting the search property list.

Duplicate a search property list

1. In Database Explorer, right-click a required search property list 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 open the generated script in a new SQL document, or To Clipboard to copy it to the clipboard.

3. Click OK.

Generate a script for a search property list

1. In Database Explorer, right-click a required search property list and select Generate Script As, then select the statement type.

2. Select one of the following output options:

• 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 search property list

To view properties of a search property list, in Database Explorer, right-click the search property list or Search Property Lists node and select Show Details.

Object Viewer opens, displaying detailed information about the search property list.

Refresh search property lists

To update the search property list to reflect the latest changes, in Database Explorer, right-click the search property list or Search Property Lists node and select Refresh, or press F5.

Open the Properties window

To open the Properties window, in Database Explorer, right-click the search property list and select Properties, or press F4.

Filter search property lists

1. In Database Explorer, right-click the Search Property Lists 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 Search Property Lists 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 search property list

The following table describes the shortcut menu options, which appear when you right-click a specific search property list in Database Explorer.

Shortcut menu options for the Search Property Lists node

The following table describes the shortcut menu options, which appear when you right-click the Search Property Lists 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 search property lists. Then right-click the selection and select the required option.

The following table describes the shortcut menu options available for multiple search property lists.