WebSphere V5.0 : Defining a table

WebSphere V5.0 : Defining a table

In this tutorial you will learn about, WebSphere V5.0 : Defining a table, Steps to define a table in your database.

Tables are logical structures maintained by the database manager. Tables are made up of columns and rows. You can define tables as part of your data definitions in the Data perspective. Before you can define a table, you must first have a database and a schema defined.

To define a table in your database, follow these steps:

In the Data Definition view of the Data perspective, select the Tables folder under your schema.

From the pop-up menu of the folder, click New > New table definition to open the New Table Definition wizard.

3. Follow the prompts in the wizard to define table properties, add columns, and define primary and foreign keys.