Database Criteria

How do I limit the number of tables to those with a certain prefix?

There exists a parameter to limit the tables you view in the database painter.  Here’s the language you need.

• Click the DB profile tool bar button

• Select the profile you want and click EDIT (this action displays the DATABASE PROFILE SETUP dialogue)

• Select the SYSTEM tab

• Go to the TABLE CRITERIA section and type   ,W11559,”TABLE” (or replace W11559 with whichever account you want)

• Click OK (this action returns you to the DATABASE PROFILES dialogue)

• Click CONNECT