CatalogDeletedProducts Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The CatalogDeletedProducts table contains information about items that have been deleted from the catalog to which the table refers. There is one CatalogDeletedProducts table for each catalog in your system. The Catalog System creates this table when it creates the catalog. The table name has the format <CatalogName>_CatalogDeletedProducts.
The following table describes the columns in the CatalogDeletedProducts table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_ClassType |
int |
no |
The class type of the deleted catalog item. This is a primary key. |
UniqueID |
nvarchar(256) |
no |
The ID of the deleted item. This is a primary key. |
VariantID |
nvarchar(256) |
no |
The variant ID of the deleted item. This is a primary key. |
DeletedDate |
datetime |
no |
The date the item was deleted. |