Select Table Type Filter - IBM Database Add-Ins for Visual Studio

Use the Select Table Type Filter window to select the types of tables that you want to see in the Server Explorer under a data connection. You can select either the default table types for a data server or the data types to show for a specific data connection.

If the check box for a given table type is selected, tables of that type are shown under a data connection for the appropriate data server.

To open the Select Table Type Filter window:

To open the window from the Options window:
1. In the left box of Options window, select the IBM Database Tools node.
2. In the Database Access category of the IBM Database Tools page, click for the Table Type Filter option.
To open the window from the Add Connection or Modify Connection window:
1. In the Add Connection or Modify Connection window, expand Specify filtering options.
2. Click for the Table type filter field.

DB2 for Linux, UNIX, and Windows (LUW): Select the check boxes for one or more of the following table types in a connection to a DB2^® for Linux^®, UNIX^®, and Windows^® server:
   T - Table (untyped)
   H - Hierarchy table
   S - Materialized query table
   U - Typed table
   N - Nickname
DB2 for i (iSeries): Select the check boxes for one or more of the following table types in a connection to a DB2 for iSeries^® server:
   T - Table
   L - Logical
   P - Physical
DB2 for z/OS (zOS): Select the check boxes for one or more of the following table types in a connection to a DB2 for z/OS^® server:
   T - Table
   G - Created global temporary table
   X - Auxiliary table
   N - Nickname

Select Table Type Filter (DB2)

See Also