#Parallel synonym plus

Single quotation marks must enclose each table type, and double quotation marks must enclose the whole parameter. type is varchar(100), with a default of NULL. These include TABLE, SYSTEMTABLE, and VIEW. Is a list of values, separated by commas, that gives information about all tables of the table types that are specified. In some products, it represents the server name of the table's database environment. In SQL Server, this column represents the database name. Various DBMS products support three-part naming for tables ( qualifier. qualifier is sysname, with a default of NULL. If one exists, the columns of that table are returned. If the owner is not specified and the current user does not own a table with the specified name, this procedure looks for a table with the specified name owned by the database owner. In SQL Server, if the current user owns a table with the specified name, the columns of that table are returned. If the owner is not specified, the default table visibility rules of the underlying DBMS apply. owner is nvarchar(384), with a default of NULL. Is the table owner of the table used to return catalog information. name is nvarchar(384), with a default of NULL. Is the table used to return catalog information. Transact-SQL Syntax Conventions Syntax - Syntax for SQL Server, Azure SQL Database, Azure Synapse Analytics, Parallel Data Warehouse One-way synonyms return a more narrow list of specific products.Ī word that is commonly associated with a selection of products in your catalog.Īdditional terms that have the same or similar meaning as the keyword.To determine the name of the base object of a synonym, query the sys.synonyms catalog view. One-way - Terms that are a subset of the keyword. Two-way (default) - Terms that have the same meaning as the keyword and return the same search results

Wait for up to two hours for your updates to become available in the storefront.ĭetermines if the synonyms have the same meaning as the keyword, or are a subset of the keyword.

When your synonym(s) are complete, click Publish changes.

#Parallel synonym plus

A plus sign separates each expansion term. The set of synonyms appears in the list with a one-way arrow pointing from the expansion terms to the keyword to indicate the terms are subsets of the keyword.

In this example, the keyword is “pants” and the one-way expansion terms “capris, calf-length pants, peddle-pushers” are each a subset of “pants”, but with a specific meaning. The set of synonyms appears in the list with a two-way arrow between each term that means the terms are interchangeable.Įnter the Keyword and Expansion term(s).

In this example, the keyword to match is “pants” and the set of expansion terms are “long pants, trousers, slacks”. Two-way synonymĮnter the Keyword term or phrase to be matched.Įnter the Expansion term(s) that you want to add as synonyms for the keyword. For multiple stores, set Scope to the store view where the synonym settings apply.įollow the instructions for the type of synonym that you want to create.In the Admin, go to Marketing > SEO & Search > Live Search.

Live Search can manage up to 200 synonyms per Data Space ID. Increase customer engagement by adding your own curated list of Live Search synonyms.