Administer > Stage server > WebSphere Commerce staging-enabled tables

List server-managed tables

Managed tables fall into three categories: site data tables; merchant data tables; mixed site and merchant data tables.

To list the tables managed by the staging or authoring server:

Procedure

1. Start a database command prompt session.

2. Connect to the staging or authoring database.

3. Issue one of the following SQL commands, depending on the category for which to see the list of managed tables:

   Option	Description
   Site data	select tabname from STGSITETAB
   merchant data	select tabname from STGMERTAB
   mixed site and merchant data	select tabname from STGMRSTTAB

Related concepts

Stage server

Author server

Related tasks

Enable custom tables for staging

+

Search Tips   |   Advanced Search