EXEC p_DropIdx 'IDX_HDM_REGASKDETAILS', 'T_HDM_REGASKDETAILS';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGASKDETAILS_EMP') CREATE INDEX IDX_HDM_REGASKDETAILS_EMP ON T_HDM_REGASKDETAILS ( FBEMPLOYEEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGASKDETAILS_RESULT') CREATE INDEX IDX_HDM_REGASKDETAILS_RESULT ON T_HDM_REGASKDETAILS ( FRESULTID );

EXEC p_DropIdx 'IDX_HDM_REGASKRESULT', 'T_HDM_REGASKRESULT';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGASKRESULT_EMP') CREATE INDEX IDX_HDM_REGASKRESULT_EMP ON T_HDM_REGASKRESULT ( FBEMPLOYEEID );

EXEC p_DropIdx 'IDX_HDM_REGEXAMRESULT', 'T_HDM_REGEXAMRESULT';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGEXAMRESULT_EMP') CREATE INDEX IDX_HDM_REGEXAMRESULT_EMP ON T_HDM_REGEXAMRESULT ( FBEMPLOYEEID );

EXEC p_DropIdx 'IDX_HDM_REGPROCESS', 'T_HDM_REGPROCESS';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGPROCESS_EMPLOYEE') CREATE INDEX IDX_HDM_REGPROCESS_EMPLOYEE ON T_HDM_REGPROCESS ( FBEMPLOYEEID );

EXEC p_DropIdx 'IDX_HDM_REGTRACE', 'T_HDM_REGTRACE';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGTRACE_EMP') CREATE INDEX IDX_HDM_REGTRACE_EMP ON T_HDM_REGTRACE ( FBEMPLOYEEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGTRACE_TRACE') CREATE INDEX IDX_HDM_REGTRACE_TRACE ON T_HDM_REGTRACE ( FTRACEID );

EXEC p_DropIdx 'IDX_HDM_REGEXAMDETAILS', 'T_HDM_REGEXAMDETAILS';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGEXAMDETAILS_EMP') CREATE INDEX IDX_HDM_REGEXAMDETAILS_EMP ON T_HDM_REGEXAMDETAILS ( FBEMPLOYEEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HDM_REGEXAMDETAILS_RESULT') CREATE INDEX IDX_HDM_REGEXAMDETAILS_RESULT ON T_HDM_REGEXAMDETAILS ( FRESULTID );