Catalog System Database Tables

The Catalog System stores data in several SQL Server databases. System data and data for each catalog are stored in the productcatalog database. By default, this database is named sitename_productcatalog. Temporary data is stored in the MSCS_CatalogScratch database. The Catalog System stores inventory data in the productcatalog database named sitename_productcatalog. This is the default configuration and gives the best performance. However, you can store the inventory data in different databases on the same SQL server.

Important Note:
Do not modify the tables, columns and values in the catalog databases directly. Use the Commerce Server Core Systems and business user applications to modify the databases. If you modify the databases directly, data integrity issues might result.

The topics in this section describe the tables in the Catalog System databases.

In This Section

• ProductCatalog Database Tables

• MSCS_CatalogScratch Database Tables

• How to Delete Temporary Tables from the MSCS_CatalogScratch Database

• InventoryCatalog Table

• InventoryCatalogMap Table

• InventoryDeletedItems Table

• InventoryQuantityDeltas Table

• InventorySchemaVersion Table

• InventorySkus Table

Reference

Microsoft.CommerceServer.Catalog

Microsoft.CommerceServer.Inventory

See Also

Other Resources

Developing with the Core Catalog System