Sponsored Links
WebSphere Tutorials
- WebSphere V5.0 : Building Expressions
- WebSphere V5.0 : Creating SQL statements
- WebSphere V5.0 : Applying DDL scripts to a remote database
- WebSphere V5.0 : Deploying to the database
- WebSphere V5.0 : Defining a table
- WebSphere V5.0 : Defining a database
- Working with Data in WebSphere
- WebSphere V5.0 : Debugging - JSP debugging
- WebSphere V5.0 : Debugging - Scrapbook Page
- WebSphere V5.0 : Debugging - View variables
- WebSphere V5.0 : Debugging - Step-through code
- WebSphere V5.0 : Debugging - Set breakpoints
- WebSphere V5.0 : Running Applications - Export J2EE applications
- WebSphere V5.0 : Running Applications - Run/operate server
- WebSphere V5.0 : Running Applications - Understand Session Manager
- WebSphere V5.0 : Running Applications - Configure data sources
- WebSphere V5.0 : Running Applications - Create server instance and server configuration
- WebSphere V5.0 : Web Development - Use Web Page Wizards
- WebSphere V5.0 : Web Development - Work with Web Application Deployment Descriptor
- WebSphere V5.0 : Web Development - Use content assist
Tutorials
WebSphereWebSphere V5.0 : Defining a database
Table of Contents
WebSphere V5.0 : Defining a database
WebSphere V5.0 : Defining a database - Page 2WebSphere 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.
Comments
Sponsored Links
