1、更改表名
alter table table_name rename to new_table_name;
2、删除数据
delete from table_name where 条件;
3、添加列注释
commet on column table_name.column_name is 注释内容;
4、添加新列
alter table table_name add column_name 数据类型 ;
5、修改列名称
alter table table_name rename column old_column_name to new_column_name;
6、删除主键约束
alter table table_name drop primary key;
7、修改表名称
alter table table_name rename to new_table_name;
8、删除字段名
alter table table_name drop column column_name;