/**Begin D:\PDM_UPGRADE\PDM1\CAS_constraint.sql **/
EXEC p_DropIdx 'IDX_CAS_CLAIMNOTICEBILL_CB', 'T_CAS_CLAIMNOTICEBILL';
EXEC p_DropIdx 'IDX_CAS_CLAIMNOTICEBILL_ORG', 'T_CAS_CLAIMNOTICEBILL';
EXEC p_DropIdx 'IDX_CAS_CLAIMNOTICEBILL_BANK', 'T_CAS_CLAIMNOTICEBILL';
EXEC p_DropIdx 'IDX_CAS_CLAIMNOTICEBILL_CO', 'T_CAS_CLAIMNOTICEBILL';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_CLAIMNOTICEBILL_CB') CREATE  CLUSTERED INDEX IDX_CAS_CLAIMNOTICEBILL_CB ON T_CAS_CLAIMNOTICEBILL ( FCLAIMSTATUS );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_CLAIMNOTICEBILL_ORG') CREATE INDEX IDX_CAS_CLAIMNOTICEBILL_ORG ON T_CAS_CLAIMNOTICEBILL ( FORGID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_CLAIMNOTICEBILL_BANK') CREATE INDEX IDX_CAS_CLAIMNOTICEBILL_BANK ON T_CAS_CLAIMNOTICEBILL ( FACCOUNTBANKID );


/**End D:\PDM_UPGRADE\PDM1\CAS_constraint.sql **/
