常用SQL语句

/*添加字段*/

alter table TABLE_NAME add COLUMN_NAME COLUMN_TYPE;

/*添加字段并赋值*/

alter table TABLE_NAME add COLUMN_NAME COLUMN_TYPE default 1;

/*更新字段名称*/

alter table TABLE_NAME rename column COLUMN_OLD to COLUMN_NEW;

/*修改字段数据类型*/

alter table TABLE_NAME modify COLUMN_NAME varchar2(20);

/*删除字段*/

alter table TABLE_NAME drop column COLUMN_NAME;