Running DDL scripts on a local database

You can run a DDL script on a local data definition which creates data definition objects that are defined in the script.

To run an SQL DDL script on a local database:

1. Switch to either the Data Definition view or the Navigator view in the Data perspective.

2. In the Scripts folder under a database, right-click the SQL DDL script with a file name extension .sql that you want to apply, and click Run against local. If you do not see a script, ensure that scripts are not filtered from the view. Click Menu > Filter in the Data Definition view to see current filters.

3. In the Folder field, type the name of the project or folder that contains the target database.

4. Select the database and schema that you want to apply the script to, and click Next.

5. Select the SQL statement that you want to run. The default for unqualified statements is the schema that you chose on the Target Selection page.

6. Click Finish.

There is limited parsing support for some Oracle scripts. When you edit Oracle scripts or run them on a local database, you might receive parsing errors or they will display in the tree view with an icon that indicates an error. For example, CREATE SEQUENCE, CREATE OR REPLACE TRIGGER, and END statements are not supported. However, you can ignore these errors and proceed to export these items to an Oracle server.

 

Parent topic

Deploying data objects to a database