Reviews
WebSphere TutorialsTable 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.
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
- WebSphere V5.0 : Web Development - Use Page Designer to add and modify HTML and JSP content
- WebSphere V5.0 : Web Development - Understand classpath and module dependencies
- WebSphere V5.0 : Web Development - Create resources in appropriate J2EE locations
- WebSphere V5.0 : Web Development - Create a web project
- WebSphere V5.0 : Java Development - Use property dialogues
- WebSphere V5.0 : Java Development - Use hierarchy view
- WebSphere V5.0 : Java Development - Use task view
- WebSphere V5.0 : Java Development - Use search function
- WebSphere V5.0 : Java Development - Use content assist function and declarations
- WebSphere V5.0 : Java Development - Use refactoring features
- WebSphere V5.0 : Java Development - Use Outline View and Browsing View
- WebSphere V5.0 : Java Development - Create Java project, packages, classes, methods
- WebSphere V5.0 : Workbench Basics - Use the Help feature to aid in development activities
- WebSphere V5.0 : Workbench Basics - Import to and export from the workbench
- WebSphere V5.0 : Workbench Basics - Work with Perspectives
- WebSphere V5.0 : Workbench Basics - Set workbench preferences
- WebSphere V5.0 : Workbench Basics - Create J2EE projects







