Listing 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:
- Start a database command prompt session.
- Connect to the staging or authoring database.
- 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