/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_constraint.sql **/
EXEC p_DropIdx 'IX_EB_BgControlOperLog', 'T_EB_BGCONTROLOPERLOG';
EXEC p_DropIdx 'IX_EB_BgControlOL_BT', 'T_EB_BGCONTROLOPERLOG';
EXEC p_DropIdx 'IX_EB_BgControlOL_BN', 'T_EB_BGCONTROLOPERLOG';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IX_EB_BGCONTROLOPERLOG') CREATE INDEX IX_EB_BGCONTROLOPERLOG ON T_EB_BGCONTROLOPERLOG ( FCREATEDATE  DESC ,FENTITYNUMBER ,FBILLID ,FBILLNUMBER );



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\EB_constraint.sql **/
