DB2复制表结构:
create table table_name_new as (select * from table_name_old) definition only;
复制表结构,但是不复制主键、约束、索引...
create table table_name_new like table_name_old;
添加表字段
alter table table_name add column col_name CHAR(2);
修改表字段类型:
基本语法: alter table <TABLE_NAME> alter column <COLUMN_NAME> set data type <NEW TYPE>
比如 : alter table ResZreportNew alter column flag set data type varchar(300);