Scenario


After the successful end of the product campaign the DBA has to drop the previously created column CUSTOMER_TYPE.

To drop the column, the DBA performs below operations:-

  1. DROP COLUMN customer_type from customer table using ALTER TABLE command.

  2. Verify the new definition of table from syscat.columns.


Output


After running the SQL scripts on the right pane,
Result shows column CUSTOMER_TYPE dropped from the base table CUSTOMER.