
IF EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BD_BOMVERSION') DROP INDEX T_BD_BOMVERSION.IDX_BD_BOMVERSION;
EXEC p_AlterColumn 'T_BD_BOMVERSION', 'FNUMBER', 'NVARCHAR(128)', '', '1111', ''' ''';
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BD_BOMVERSION') CREATE INDEX IDX_BD_BOMVERSION ON T_BD_BOMVERSION ( FNUMBER ,FCREATEORGID );