在SQL语言基础中，删除一列的操

丢弃一个列 * 使用 DROP COLUMN来丢弃一个表中将来不使用的列. SQL> ALTER TABLE dept30 2 DROP COLUMN job ; Table altered. * Dropping a Column You can drop a column from a table by using the ALTER TABLE statement with the DROP COLUMN clause. This is a feature available from Oracle8i onward. Guidelines The column may or may not contain data. Only one column can be dropped at a time. The table must have at least one column remaining in it after it is altered. Once a column is dropped, it cannot be recovered.