Managed tables fall into three categories: site data tables; merchant data
tables; mixed site and merchant data tables.
To list the tables that are managed by the staging or authoring environment:
Procedure
-
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 |
Attention: Some of the managed tables that are returned by the SQL commands do not have
staging triggers associated with them. Any changes that you make to these tables in the staging
database are not captured in the STAGLOG table. When you run the
stagingprop
utility, changes in these non-staged tables are not propagated from the staging database to the
production database.
To view a list of tables that contain staging triggers, issue the following
SQL command: