<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. |