Skip to content

Excluding Tables

The list of tables in the treeview is built from all the entries in the filelist that belong to the selected workspace. There are two situations in which tables are not added:

  1. If the user display name starts with an @ sign, the filelist entry is skipped.
  2. Use the Exclude Tables dialog.

Exclude Tables Dialog

This dialog can be opened from the File pulldown menu or by pressing Ctrl + F10. The dialog shows two lists:

  • The left side list shows all the included tables.
  • The right side list shows the excluded tables.

Tables can be moved from the left side to the right side or vice versa by clicking one of the buttons in the middle.

It is up to you why you want to exclude tables from the list. You might want to temporarily have a shorter list to increase work speed, or you might want to hide tables because some users should not see them.

The information will be written to the dbexplorer.ini file. This file is saved in the directory where the filelist of your workspace was found. This directory is retrieved from the psFileList property of the workspace object. If there is a problem with the path, Database Explorer will look in DfPath to see if an existing file can be found. If there is no existing file, the first directory from DfPath is used.

Sample File Content

A sample of the file content is as follows:

[ExcludedTables]
FLEXERRS=50

If you want end users to use Database Explorer and do not want all tables to be present, you can deliver this dbExplorer.ini file with your application.