设置外键

alter table table_name_1 add constraint fk_外键名字 foreign key (column_name_1) references table_name_2(column_name_2)

?

设置联合主键

alter table table_name add constraint pk_主键名字 primary key(column_name_1,column_name_2)

?删除列

alter table table_name drop column column_name

?添加列

alter table table_name add column column_name column_type

?删除表中所有数据

truncate table table_name;

?