Oracle 修改表结构的字段M_DEPARTMENT 表明SELECT * from M_DEPARTMENT --查询alter table M_DEPARTMENT d
Oracle 修改表结构的字段 M_DEPARTMENT 表明
SELECT * from M_DEPARTMENT --查询 alter table M_DEPARTMENT drop COLUMN DEPT_NUM --删除 alter table M_DEPARTMENT add (DEPT_NUM varchar(90)) --添加部门代号列 COMMENT ON COLUMN M_DEPARTMENT.DEPT_NUM IS '部门代号' --添加部门代号列注释
