To add existing tables to the database:
|1.||Open a database. See Opening a Database for details. You must login to the database as a user with CREATE TABLE permissions in order to add an existing table to the data dictionary.|
|2.||Right-click the Tables icon in the Connection Repository and select Add Existing Table(s).|
|3.||In the dialog box that appears, holding down the Ctrl key and clicking the left mouse button can select multiple tables. Once the tables are selected, click Open.|
The tables will now be displayed in the tree view.
Adding tables to the database will ensure that all changes made to that table will be in accordance with the constraints and RI set up in the database. This will prevent possible logical table corruption.
Adding an ADT table to the database will change the table header so that the table is bound to the database. The ADT table will not open without a database connection.