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:
-
In SQL Developer, navigate to the PURCHASE_ORDERS
table in the HR schema, following the instructions in "Viewing Tables".
-
Right-click the PURCHASE_ORDERS
table and select Edit.
The Edit Table dialog box appears.
-
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.
-
Click OK.
-
On the PURCHASE_ORDERS
table tab in the object pane, click the Columns subtab to view the list of columns in the table.