/**Begin D:\pdm\PDM_UPGRADE\pdm_new\RIM_constraint.sql **/
 EXEC p_AlterPK 'PK_T_RIM_STRUCTURED_DATA', 'T_RIM_STRUCTURED_DATA', 'fid', '0';
EXEC p_DropIdx 'IDX_RIM_STRUCTURED_DATA_NUM', 'T_RIM_STRUCTURED_DATA';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RIM_STRUCTURED_DATA_NUM') CREATE  CLUSTERED INDEX IDX_RIM_STRUCTURED_DATA_NUM ON T_RIM_STRUCTURED_DATA ( FNUMBER ,FNAME );

 EXEC p_AlterPK 'PK_T_RIM_STRUCTURED_ITEM', 'T_RIM_STRUCTURED_ITEM', 'fid', '0';
EXEC p_DropIdx 'IDX_RIM_STRUCTURED_ITEM_NUM', 'T_RIM_STRUCTURED_ITEM';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RIM_STRUCTURED_ITEM_NUM') CREATE  CLUSTERED INDEX IDX_RIM_STRUCTURED_ITEM_NUM ON T_RIM_STRUCTURED_ITEM ( FNUMBER ,FNAME );

 EXEC P_ALTERPK 'PK_RIM_STRUCTURED_DATA_L', 'T_RIM_STRUCTURED_DATA_L', 'FPKID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RIM_STRUCTURED_DATA_L_0') CREATE  CLUSTERED INDEX IDX_RIM_STRUCTURED_DATA_L_0 ON T_RIM_STRUCTURED_DATA_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_RIM_STRUCTURED_ITEM_L', 'T_RIM_STRUCTURED_ITEM_L', 'FPKID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RIM_STRUCTURED_ITEM_L_0') CREATE  CLUSTERED INDEX IDX_RIM_STRUCTURED_ITEM_L_0 ON T_RIM_STRUCTURED_ITEM_L ( FID ,FLOCALEID );



/**End D:\pdm\PDM_UPGRADE\pdm_new\RIM_constraint.sql **/
