WebSphere V5.0 : Defining a database

WebSphere V5.0 : Defining a database

In this tutorial you will learn about WebSphere V5.0 : Defining a database, Create schema and generate DDL.

To define a database, you must have a project defined. Once your project is defined, follow these steps:

1. To access the Data Definition view:

a. Click Window > Open Perspective > Other to open the Select Perspective dialog.

b. Select Data and click OK.

c. Select the Data Definition tab to switch to the Data Definition view if it is not already showing.

2. From the pop-up menu of a project where you want to create the database, click New > New database definition. The New Database Definition wizard opens.

3. In the Database name field, type the name of the database that you want to create.

4. Select the database vendor type. When you generate SQL DDL for your schemas, it conforms to the database type that you select here.

5. Click Finish. The wizard closes, and your database appears under the project folder.

Defining a schema

After you have created a database, you can define schemas to organize the tables and other data objects.

To define a schema, follow these steps after you have defined a database:

1. Switch to the Data perspective's Data Definition view.