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)
页:
[1]