Database SQL Script

This chapter is composed of :

1. Introduction
2. Database SQL Script
   1. Database SQL Script Page
      1. Script Name
   2. Finish

1. Introduction

The purpose of this chapter is to show how to create an empty SQL Script.

2. Database SQL Script

To start the Database SQL Script wizard, select :

File->New->Other->Database->Database SQL Script

or

Select an object in the Package Explorer View or the Navigator View then right-click and select :

New->Other->Database->Database SQL Script

This means that if you select an existing Database Object :

The wizard will open the parent Database Connection in update mode.

Otherwise :

A new Database Connection wizard will be opened starting with a New Folder selector.

In Database Connection Update mode this wizard has four pages :

• New Database SQL Script
• Database Connection Update
• Database Schema Update
• Database Schema DTD Update

In Database Connection Create mode this wizard has five pages :

• New Folder
• New Database SQL Script
• New Database Connection
• New Database Schema
• New Database Schema DTD

2.1. Database SQL Script Page

2.1.1. Script Name

Script Name is the name of your new SQL script.

Each resource should have a unique name in the targeted selected workspace folder or project root.

This data is not related to any Meta Data informations.

This name will be the file name of the generated SQL script file.

This Script is an SQL file, its file extension is :

• .sql

This file is referenced in your current Database Connection.

2.2. Finish

The script generation of the new Database SQL Script will be created.