Oracle 表、主键的增删改

表字段：

alter table tablename add (column datatype [default value][null/not null],….);

alter table tablename modify (column datatype [default value][null/not null],….);

alter table tablename drop (column);

添加、修改、删除多列的话，用逗号隔开

表：

alter table tablename rename to new_table_name;

主键：

select constraint_name from user_cons_columns a where a.table_name='tablename';
alter table tablename add constraint pk_name primary key(column);
alter table tablename drop constraint constraint_name;
alter table tablename disable primary key;
alter table tablename enable primary key;
alter table tablename rename constraint pk_id to new_pk_id;

 

来源链接: https://www.cnblogs.com/liushenghuan/p/5749484.html