Listing server-managed tables


Managed tables fall into three categories:

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

  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 you want 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


Staging server
Authoring server

 

Related tasks


Enabling custom tables for staging