Skip Headers

# Generating SQL Creation Scripts

Previous

Next

Using the TopLink Workbench, you can generate SQL scripts that you can use to create tables in a relational database.

To automatically generate SQL scripts to create the tables in a project, use this procedure:

1. Select the database table(s) in the Navigator.

2. Right-click the table(s) and choose Generate Creation Script for > Selected Table or All Tables from the context menu. The SQL Creation Script dialog box appears.

   You can also choose Selected > Generate Creation Script for > Selected Table or All Tables from the menu.

Copy the script and paste it into a file. You may need to edit the file to include additional SQL information that TopLink Workbench could not generate. If the database table or column name is an SQL reserved word, you must edit the SQL script and enclose the database table or column in quotes. See "Oracle Database Reserved Words" in the Oracle Database SQL Reference Guide for more information.

Note: If TopLink cannot determine how a particular table feature should be implemented in SQL, it generates a descriptive message in the script.

See Also

Generating Data From Database Tables