Full-text stoplists

A full-text stoplist is a list of stopwords that is applied to full-text queries on the associated full-text index.

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

Create a full-text stoplist

1. On the SQL toolbar, click New SQL.

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

CREATE FULLTEXT STOPLIST stoplist_name  
[ FROM { [ database_name.]source_stoplist_name } | SYSTEM STOPLIST ]  
[ AUTHORIZATION owner_name ]  
;

where:

• stoplist_name is a unique name of the full-text stoplist you want to create.
• database_name is the name of the database where the stoplist is created. If the database isn’t specified, the current database is used by default.
• source_stoplist_name specifies that the new stoplist is created as a copy of an existing stoplist. If source_stoplist_name doesn’t exist, or if the database user doesn’t have the required permissions, the CREATE FULLTEXT STOPLIST statement fails and returns an error.
• owner_name is the name of a principal that the current user belongs to, or a principal the user has IMPERSONATE permission for. If not provided, the current user becomes the owner.

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

Delete a full-text stoplist

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

Duplicate a full-text stoplist

1. In Database Explorer, right-click a required full-text stoplist 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 full-text stoplist

1. In Database Explorer, right-click a required full-text stoplist 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 full-text stoplist

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

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

Refresh full-text stoplists

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

Open the Properties window

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

Filter full-text stoplists

1. In Database Explorer, right-click the Full-Text Stoplists 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 Stoplists 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 stoplist

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

Shortcut menu options for the Full-Text Stoplists node

The following table describes the shortcut menu options, which appear when you right-click the Full-Text Stoplists 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 stoplists. Then right-click the selection and select the required option.

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