SQL Script

The SQL Script window scripts SQL CREATE statements for database objects, using the SQL dialect of the database the Datastore is connected to in the Provider Tab. SQL Script appears as a context menu option for different items in the Datastore:

When SQL Script is opened for a Datastore, it scripts all the Tables and Views in the Datastore.

SQL Script can be opened for a Table or View to only script that entity.

The SQL script can be run from the SQL Script window by hitting F5, or by clicking the Execute Script button on its toolbar. The connection defined in the Provider Tab is used to execute the script.

Example: SQL Script for a Datastore connected to an Oracle database.

See also

You can also execute AdHoc SQL statements from the Database Repository.