靠,多看看Oracle的帮助文档吧.Alter table XX Add/Modify yy datatype;Alter table XX Drop Column yy;
Alter Table tbl_localperson1 drop column flagid; 误位于第1行: A-00905: 缺少关键字我以前试过,报这个错误,我用的是oracle8。
添加修改表结构的: Alter table XX Add yy datatype; 修改表结构的: Alter table XX Modify yy datatype; 删除表结构的: Alter table XX Drop Column yy;
前两个都对,最后一个报错。 Alter Table tbl_localperson1 drop column flagid; 误位于第1行: A-00905: 缺少关键字
drop_constraint_clause The drop_constraint_clause lets you drop an integrity constraint from the database. Oracle stops enforcing the constraint and removes it from the data dictionary. You can specify only one constraint for each drop_constraint_clause, but you can specify multiple drop_constraint_clauses in one statement. PRIMARY KEY Specify PRIMARY KEY to drop the table's PRIMARY KEY constraint.
UNIQUE Specify UNIQUE to drop the UNIQUE constraint on the specified columns.
CONSTRAINT constraint Specify the integrity constraint you want dropped.
CASCADE Specify CASCADE if you want all other integrity constraints that depend on the dropped integrity constraint to be dropped as well.
误位于第1行:
A-00905: 缺少关键字我以前试过,报这个错误,我用的是oracle8。
Alter table XX Add yy datatype;
修改表结构的:
Alter table XX Modify yy datatype;
删除表结构的:
Alter table XX Drop Column yy;
Alter Table tbl_localperson1 drop column flagid;
误位于第1行:
A-00905: 缺少关键字
The drop_constraint_clause lets you drop an integrity constraint from the database. Oracle stops enforcing the constraint and removes it from the data dictionary. You can specify only one constraint for each drop_constraint_clause, but you can specify multiple drop_constraint_clauses in one statement. PRIMARY KEY
Specify PRIMARY KEY to drop the table's PRIMARY KEY constraint.
UNIQUE
Specify UNIQUE to drop the UNIQUE constraint on the specified columns.
CONSTRAINT constraint
Specify the integrity constraint you want dropped.
CASCADE
Specify CASCADE if you want all other integrity constraints that depend on the dropped integrity constraint to be dropped as well.
还有我想把blob字段改成varhcar2为什么出错(就为了试一下)