<CatalogName>_<LanguageIdentifier>_Catalog Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The <CatalogName>_<LanguageIdentifier>_Catalog table contains information about the languages in the catalog to which the table refers. There is one LanguageIdentifier_Catalog table for each language in the catalog. The Catalog System creates the first table when you create a catalog. The system adds another table for each language that you add to your catalog.

The table name has the format <CatalogName>_<Language Identifier>_Catalog. For example, if the active language for your catalog is English, this table name is <CatalogName>_en-US_Catalog.

This table will have additional columns for each custom multilingual property that you create. If you create non-multilingual properties, they are listed in the CatalogProducts Table.

The following table describes the columns in the <CatalogName>_<LanguageIdentifier>_Catalog table.

Column name

Type

Allow null

Description

#Catalog_Lang_Oid

int

no

The object ID (OID) of the active language.

This is a primary key and a foreign key.

#Catalog_Lang_Timestamp

timestamp

no

The timestamp for the catalog.

DisplayName

nvarchar(128)

yes

The display name of the catalog item.

See Also

Other Resources

Database Tables for Product Catalogs

Catalog System Database Tables