In order for the Data Masker to function, it needs to be aware of the tables in the target schema and their structure (column names, column types, column sizes etc). This information can be acquired in two ways. When the Data Masker loads an existing Masking Set file it reads the .schema file and becomes aware of the tables. If a new Masking Set is being created, the schema structure is downloaded automatically as part of the New Set Wizard or manually using the "Get Schema Information from DB" button on the Misc. Setup Tab.

The Data Masker Set Tables Tab

The panel on the top of the Set Tables Tab shows the tables in the Masking Set. Beside each table is a column indicating the number of rows in the table and the number of rules applied to it. The target row counts are obtained via the Masking Set .rowcount file which, in turn, was obtained via the Get Table Row Counts from Schema dialog box.

If the required table is not present in the list then the schema information will probably need to be refreshed again. Use the "Refresh Schema Information from DB" button on the Misc Setup tab to reload this information.

Selecting the table name in the top panel will cause the columns for that table to appear in the bottom right hand Table Columns list view.

Note:A right mouse button click on any table name will cause a small menu to appear offering the option to see the columns, foreign keys and indexes for a particular table.

What the Buttons do

Discard Table

The Discard Table button removes the table name from the Data Maskers knowledge. If the table has rules these rules will also be dropped. Note that discarding a table has no affect on the table in the target schema - it just means that the Data Masker application no longer knows about it.

Hide Tables with Zero Src. Rows

Sometimes a schema will have many tables containing no rows at all. This option simply removes them from the display without actually removing them from the Masking Set.