感傷的2005年底
家族發生二件大事
唉…
心情感傷, 更要努力向上~
Month: December, 2005
感傷的2005年底
家族發生二件大事
唉…
心情感傷, 更要努力向上~
Can one drop a column from a table?
Can one drop a column from a table?
Can one drop a column from a table?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.
Other workarounds: 1. SQL> update t1 set column_to_drop = NULL;
SQL> rename t1 to t1_base;
SQL> create view t1 as [...]