Select Tables/Views/Aliases

Select the types of tables, views, or aliases required in the OTD.

To Select Table/Views/Aliases

1. In the Select Tables/Views/Aliases window, click Add. See the following figure.

   

2. In the Add Tables window, select if your selection criteria will include table data, view only data, both, and/or system tables.

3. From the Table/View Name drop down list, select the location of your database table and click Search. See the following figure.

   

4. Select the table of choice and click OK.

   The table selected is added to the Selected Tables/Views/Aliases section. See the following figure.

   

5. In the Selected Tables/Views/Aliases section, review the table(s) you have selected. To make changes to the selected Table or View, click Change. If you do not wish to make any additional changes, click Next to continue.

6. In the Table/View Columns window, you can select or deselect your table columns. You can also change the data type for each table by highlighting the data type and selecting a different one from the drop down list. If you would like to change any of the tables columns, click Change. See the following figure.

   The data type is usually listed as Other when the driver cannot detect the data type. In these situations we recommend changing the data type to one that is more appropriate for the type of column data.

   

7. Click Advanced to change the data type, precision/length, or scale. Once you have finished your table choices, click OK. In general, you will not need to make any changes. See the following figure.