ALTER 操作

--新增列
ALTER TABLE Table_name ADD column_name column_type(varchar2(1)) DEFAULT '0' not null;

--删除主键
ALTER TABLE table_name drop constraint PK_name;

--新增主键
ALTER TABLE t_wop_dsr add constraint PK_name primary key(column_name<,...>);

--添加外键
ALTER TABLE table_A ADD constraint FK_name FOREIGN KEY(column_name) REFERENCES table_B(column_name);

--trigger 控制
alter trigger TRI_NAME disable;
commit;

alter trigger TRI_NAME enable;
commit;