Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can one drop a column from a table?

April 26, 2017column drop Table

0

Posted

Can one drop a column from a table?

1 Answer

0

Posted

From Oracle8i one can DROP a column from a table. Look at this sample script, demonstrating the ALTER TABLE table_name DROP COLUMN column_name; command. With previous releases one can use Joseph S. Testa‘s DROP COLUMN package that can be downloaded from http://www.oracle-dba.com/ora_scr.htm. Other workarounds: 1. SQL> update t1 set column_to_drop = NULL; SQL> rename t1 to t1_base; SQL> create view t1 as select from t1_base; 2.