表字段:
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;