Example: Deleting a Table Column

In this example, you delete the po_requestor_name column that you added to the purchase_orders table in "Example: Adding Table Columns".

To delete the PO_REQUESTOR_NAME column:

1. Go to the Database Home page, logging in as user nick or as user SYSTEM.

   See "Accessing the Database Home Page".

2. At the top of the page, click Schema to view the Schema subpage.

3. In the Database Objects section, click Tables.

   The Tables page appears.

4. In the Schema field, enter nick and then click Go.

   All tables owned by user nick are displayed.

5. Select the PURCHASE_ORDERS table, and then click Edit.

   The Edit Table page appears.

6. In the Columns section, select the PO_REQUESTOR_NAME column, and then click Delete.

   The row that contained the information for the deleted column becomes blank.

7. Click Apply.

   An update message appears indicating that the table has been modified successfully.