/**Begin D:\pdm\PDM_UPGRADE1\PDM1\HDM_constraint.sql **/
EXEC p_DropIdx 'IDX_HDM_AFTER_FDEPEMPID', 'T_HDM_AFTERTRANSFER_D';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_TRANAFTER_FDEPEMPID') CREATE INDEX IDX_HDM_TRANAFTER_FDEPEMPID ON T_HDM_AFTERTRANSFER_D ( FDEPEMPID );

EXEC p_DropIdx 'IDX_HDM_AFTER_EMPLOYEEID', 'T_HDM_AFTERTRANSFER_E';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_TRANAFTER_EMPLOYEEID') CREATE INDEX IDX_HDM_TRANAFTER_EMPLOYEEID ON T_HDM_AFTERTRANSFER_E ( FEMPLOYEEID );

EXEC p_DropIdx 'IDX_HDM_AFTER_PERSONID', 'T_HDM_AFTERTRANSFER_P';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_TRANAFTER_PERSONID') CREATE INDEX IDX_HDM_TRANAFTER_PERSONID ON T_HDM_AFTERTRANSFER_P ( FPERSONID );

EXEC p_DropIdx 'IDX_HDM_BEFORE_DEPEMPID', 'T_HDM_BEFORETRANSFER_D';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_TRANBEFORE_DEPEMPID') CREATE INDEX IDX_HDM_TRANBEFORE_DEPEMPID ON T_HDM_BEFORETRANSFER_D ( FDEPEMPID );

EXEC p_DropIdx 'IDX_HDM_BEFORE_EMPLOYEEID', 'T_HDM_BEFORETRANSFER_E';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_TRANBEFORE_EMPLOYEEID') CREATE INDEX IDX_HDM_TRANBEFORE_EMPLOYEEID ON T_HDM_BEFORETRANSFER_E ( FEMPLOYEEID );

EXEC p_DropIdx 'IDX_HDM_BEFORE_PERSONID', 'T_HDM_BEFORETRANSFER_P';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_TRANBEFORE_PERSONID') CREATE INDEX IDX_HDM_TRANBEFORE_PERSONID ON T_HDM_BEFORETRANSFER_P ( FPERSONID );


/**End D:\pdm\PDM_UPGRADE1\PDM1\HDM_constraint.sql **/
