Modify Table Filter

The table filter in SmartGuide step to Select Tables for Mapping enables you to reduce the number of tables to be displayed when you click Get tables. This is useful when the database you are accessing contains many tables. To set the table filter:

  1. Type wild cards in the Owner name and Table name entry fields. Owner and table names are case-sensitive. Two wild cards are valid:

    ? is a single character wild card
    * is a multiple character wild card

  2. Click on the Table type list box to see the different types of tables available for the filter. Select the type of filtering you want.

Note: Data Access Builder has a limit of how many tables can be displayed in the Tables list box. The exact limit depends on your machine and the size of its virtual memory. If your database has many tables (in the order of several thousand), try to use a specific filter.



Start the SmartGuide