-- drop column
EXEC p_AlterColumn 'T_BD_BEBANK', 'FBANKCATEG', 'NULL', 'NULL', '1001', 'NULL';

-- rebuild column
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_BEBANK' AND KSQL_COL_NAME IN ('FBANKCATEG')) 
ALTER TABLE T_BD_BEBANK ADD (FBANKCATEG VARCHAR(100) );
