CatalogGlobal Table
The CatalogGlobal table contains information about the global properties for catalogs in the Catalog System.
The following table describes the columns in the CatalogGlobal table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
CatalogName |
nvarchar(85) |
no |
The name of the catalog. |
Locale |
int |
yes |
The locale. |
StartDate |
datetime |
yes |
The date at which the catalog is active. |
EndDate |
Datetime |
yes |
The date at which the catalog is no longer active. |
VariantId |
nvarchar(128) |
yes |
The Id of the variant. |
ProductId |
nvarchar(128) |
yes |
The Id of the product. |
Currency |
nvarchar(128) |
yes |
The currency used in the catalog. |
WeightMeasure |
nvarchar(128) |
yes |
The weight measure that is used in the catalog. |
TimeStamp |
timestamp |
no |
The timestamp of the catalog. |
CatalogId |
int |
no |
The Id of the catalog. This is a primary key. |
CustomCatalog |
bit |
yes |
Specifies whether this is a custom catalog. |
FreeTextIndexCreated |
datetime |
yes |
The time the free text index was created. |
ProductTableUpdate |
datetime |
no |
The time the product table was last updated. |
FullTextCatalog |
sysname(nvarchar(128)) |
yes |
The name of the associated full text catalog. |
DefaultLanguage |
nvarchar(10) |
yes |
The default language of the catalog. |
ReportingLanguage |
nvarchar(10) |
yes |
The reporting language of the catalog. |
IsVirtualCatalog |
samllint |
no |
Specifies if this is a virtual catalog. |
VirtualCatalogStatus |
smallint |
no |
The status of the virtual catalog. |
CatalogFlags |
int |
no |
Specifies whether the virtual catalog is materialized or non-materialized. |
IsVirtualCatalogView |
bit |
no |
Specifies if this is a virtual catalog of a virtual catalog. |
FtsMaterializedTime |
varbinary(8) |
yes |
The time the catalog was materialized. |
DisplayName_* |
nvarchar(100) |
yes |
The display name of the catalog in the specified language. The name of this column depends on the language identifier. For example, if the catalog language identifier is English, the column name is DisplayName_en-US. |