DB2表维护常用SQL

--CREATE TABLE XPROMOTIONDESCBACK AS (SELECT * FROM XPROMOTIONDESC) DEFINITION ONLY
--insert into XPROMOTIONDESCBACK select * from XPROMOTIONDESC
--drop table XPROMOTIONDESC
--CREATE TABLE XPROMOTIONDESC
--insert into XPROMOTIONDESC select * from XPROMOTIONDESCBACK

--显示表结构
--select * from sysibm.syscolumns where tbname = 'XPROMOTIONDESC'

--更新某列大小
--alter table XPROMOTIONDESC alter column BATCHDESC set data type varchar(254)