1、添加列
ALTER TABLE table_name ADD [COLUMN] col_name column_definition
[FITRST | ALTER col_name];
2、删除列
ALTER TABLE table_name DROP [COLIMN] col_name;
3、添加主键约束
ALTER TABLE table_name ADD [CONSTRAINT[symbol]] PRIMARY KEY [index_type](index_col_name,...);
4、添加唯一约束
ALTER TABLE table_name ADD[CONSTRAINT [symbol]]UNIQUE [INDEX|KEY][index_name][index_type](index_col_name,....);
5、添加外键约束
ALTER TABLE table_name ADD [CONSTRAINT[symbol]]FOREIGN KEY [index_name](index_col_name,...)REFERENCES tbl_name (index_col_name, ...);
6、删除主键约束
ALTER TABLE table_name DROP PRIMARY KEY;
7、删除唯一约束
ALTER TABLE tbl_name DROP {INDEX|EKY}index_name;
8、删除外键约束
ALTER TABLE table_name DROP FOREIDGN KEY col_name;
9、修改列定义
ALTER TABLE table_name MODIFY [CONLIMN]col_name column_definition [FIRST | AFTER col_name]
10、修改列名称
ALTER TABLE table_name CHANGE[COLUMN]old_col_name new_col_name column_definition [FIRST|AFTER col_name]
11、数据表更名
方法一
ALTER TABLE table_name RENAME[TO|AS] new_table_name
方法二
RENAME TABLE table_name TO new _table_name[,table_name2 TO new _table_name2]...;
ALTER TABLE table_name ADD [COLUMN] col_name column_definition
[FITRST | ALTER col_name];
2、删除列
ALTER TABLE table_name DROP [COLIMN] col_name;
3、添加主键约束
ALTER TABLE table_name ADD [CONSTRAINT[symbol]] PRIMARY KEY [index_type](index_col_name,...);
4、添加唯一约束
ALTER TABLE table_name ADD[CONSTRAINT [symbol]]UNIQUE [INDEX|KEY][index_name][index_type](index_col_name,....);
5、添加外键约束
ALTER TABLE table_name ADD [CONSTRAINT[symbol]]FOREIGN KEY [index_name](index_col_name,...)REFERENCES tbl_name (index_col_name, ...);
6、删除主键约束
ALTER TABLE table_name DROP PRIMARY KEY;
7、删除唯一约束
ALTER TABLE tbl_name DROP {INDEX|EKY}index_name;
8、删除外键约束
ALTER TABLE table_name DROP FOREIDGN KEY col_name;
9、修改列定义
ALTER TABLE table_name MODIFY [CONLIMN]col_name column_definition [FIRST | AFTER col_name]
10、修改列名称
ALTER TABLE table_name CHANGE[COLUMN]old_col_name new_col_name column_definition [FIRST|AFTER col_name]
11、数据表更名
方法一
ALTER TABLE table_name RENAME[TO|AS] new_table_name
方法二
RENAME TABLE table_name TO new _table_name[,table_name2 TO new _table_name2]...;