/**Begin D:\d_desk\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_BDM_MATCH_REDCONFIRM_L', 'T_BDM_MATCH_REDCONFIRM_L', 'FPKID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_MATCH_REDCONFIRM_L') CREATE  CLUSTERED INDEX IDX_BDM_MATCH_REDCONFIRM_L ON T_BDM_MATCH_REDCONFIRM_L ( FID );


 EXEC P_ALTERPK 'PK_T_BDM_MATCH_REDCONFIRM', 'T_BDM_MATCH_REDCONFIRM', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_MATCH_REDCONFIRM') CREATE  CLUSTERED INDEX IDX_BDM_MATCH_REDCONFIRM ON T_BDM_MATCH_REDCONFIRM ( FNUMBER );



/**End D:\d_desk\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_constraint.sql **/
