增加一列:
alter table tb_name add cl_name data_type;
增加多列时列名要用括号括起来并用逗号隔开
alter table tb_name add (cl_name cl_defination,......)
删除一列:
alter table tb_name drop cl_name;
alter table tb_name drop cl_name1,drop cl_name2...;
添加主键约束:
alter table tb_name add primary key(pk_name);
添加唯一约束:
alter table tb_name add unique key(uk_name);
添加外键约束:
alter table tb_name add foreign key(index) references re_name(re_index);
alter table tb_name drop priamry key;
删除唯一约束:
alter table tb_name drop {index | key} index_name;
alter table tb_name drop foreign key fk_name;
数据表更名:
alter table tb_name rename new_name;