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

IF EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_DATAPERM_MODEL') DROP INDEX T_EB_DATAPERM.IDX_EB_DATAPERM_MODEL;

IF EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_DATAPERM_DIMENSION') DROP INDEX T_EB_DATAPERM.IDX_EB_DATAPERM_DIMENSION;

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_DATAPERM_P1') CREATE INDEX IDX_EB_DATAPERM_P1 ON T_EB_DATAPERM ( FMODEL,FDIMENSION,FBUSINESSMODEL );


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