what Oracle version are you using? In Oracle 8i, you can drop a column using: ALTER TABLE xxx DROP COLUMN yyyIn Oracle versions 8.0 and older, you can't drop a column, try to create a new table with the columns you want, copy the data to the new table from the old table, dump the old table and rename the new one
语法没错,但是只有8I以上的ORACLE才能删除列
8i之前是不能修改table 栏位的。因此8i以后的版本才能删掉column!alter table ttt drop column aa
ORACLE8i以上的版本才支持此命令: alter table talbe_name drop column column_name;
实际上还有很多限制条件: You cannot do the following: • Drop a column from an object type table • Drop columns from nested tables • Drop all columns in a table • Drop a partitioning key column • Drop a column from tables owned by SYS • Drop a parent key column • Drop a column from an index-organized table if the column is a primary key
ALTER TABLE xxx DROP COLUMN yyyIn Oracle versions 8.0 and older, you can't drop a column, try to
create a new table with the columns you want, copy the data to the new table from the old table, dump the old table and rename the new one
alter table talbe_name drop column column_name;
You cannot do the following:
• Drop a column from an object type table
• Drop columns from nested tables
• Drop all columns in a table
• Drop a partitioning key column
• Drop a column from tables owned by SYS
• Drop a parent key column
• Drop a column from an index-organized table if the column is a primary key