Skip Headers

# Importing Tables From a Database

Previous

Next

TopLink Workbench can automatically read the schema for a relational database and import the table data into the project as long as your JDBC driver supports the following JDBC methods:

- `getTables`

- `getTableTypes`

- `getImportedKeys`

- `getCatalogs`

- `getPrimaryKeys`

The JDBC driver must be on the TopLink Workbench classpath (see "Configuring the TopLink Workbench Environment").

To import tables from the database, use the following procedure:

1. Select the database object in the Navigator, and click Add/Update Existing Tables from Database. The Import Tables from Database dialog box appears.

   You can also right-click on the database object in the Navigator and choose Add/Update Existing Tables from Database from the context menu or choose Selected > Add/Update Existing Tables from Database from the menu.

2. Complete each field on the Import Tables from Database dialog box and click OK.

Examine each table's properties to verify that the imported tables contain the correct information. See "Working With Database Tables in the Editor Window" for more information.

See Also

  Working With Database Tables in the Navigator Window
  Working With Database Tables in the Editor Window