Deleting a Table Column - wykład

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" on page 8-13.
To delete the PO_REQUESTOR_NAME column:
1. Navigate to the PURCHASE_ORDERS table in the HR schema, following the
instructions in "Viewing Tables" on page 8-10.
2. Right-click the PURCHASE_ORDERS table and select Edit.
The Edit Table dialog box appears.
3. In the Columns section, click the PO_REQUESTOR_NAME column, and then click the
red X icon.
The PO_REQUESTOR_NAME column is removed from the list of columns.
4. Click OK.
5. On the PURCHASE_ORDERS table tab in the object pane, click the Columns subtab to
view the list of columns in the table.
... zobacz całą notatkę