Contents Index Reverse engineer the database Lesson 3: Check your work

Introducing SQL Anywhere Studio
   Tutorial: Designing Databases with PowerDesigner

Lesson 2: Add a column


You are now ready to add the unit_price column to the sales_order_items table. You can accomplish this task by accessing the list of columns through the Table property sheet.

To add a column

  1. Display the column properties:

  2. Add a new column to hold the unit price.

  3. Examine the effect of your changes on the diagram of the database. The sales_order_items table now includes a new column called unit_price.


Contents Index Reverse engineer the database Lesson 3: Check your work