Example: Deleting a Table Column

In this example, you use SQL Developer to 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. In SQL Developer, navigate to the PURCHASE_ORDERS table in the HR schema, following the instructions in "Viewing Tables".
  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.

See Also:

" About Tables"