/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BASE_constraint.sql **/
EXEC p_DropIdx 'IDX_BD_SUPPLIERADD_UN', 'T_BD_SUPPLIERADD';
EXEC p_DropIdx 'IDX_BD_CUSTOMERADD_UN', 'T_BD_CUSTOMERADD';
 EXEC p_AlterPK 'PK_T_BD_CUSTOMER_B', 'T_BD_CUSTOMER_B', 'fid', '0';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'INDEX_BD_CUSTOMER_B_IDNO') CREATE  CLUSTERED INDEX INDEX_BD_CUSTOMER_B_IDNO ON T_BD_CUSTOMER_B ( FIDNO );

 EXEC p_AlterPK 'PK_T_BD_SUPPLIER_B', 'T_BD_SUPPLIER_B', 'FID', '0';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'DX_T_BD_SUPPLIE_B_IDNO') CREATE  CLUSTERED INDEX DX_T_BD_SUPPLIE_B_IDNO ON T_BD_SUPPLIER_B ( FIDNO );


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