IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INVELIMTEMPLATE' AND KSQL_COL_NAME ='FBILLSTATUS') 
 ALTER TABLE T_BCM_INVELIMTEMPLATE ADD (FBILLSTATUS CHAR(1) DEFAULT 'A' NOT NULL );
 
 
  --- drop TABLE --------- 请认真检查该脚本 ------------------- 
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BCM_INVELIMTEMPLATEENTRY') 
 DROP TABLE T_BCM_INVELIMTEMPLATEENTRY;
 
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_INVELIMTEMPLATE' AND KSQL_COL_NAME ='FADJUSTMENT') 
 ALTER TABLE T_BCM_INVELIMTEMPLATE ADD (FADJUSTMENT CHAR(1) DEFAULT '0' NOT NULL );