/**Begin D:\PDM_UPGRADE\PDM1\TM_constraint.sql **/
 EXEC P_ALTERPK 'PK_TM_REQNOTE', 'T_TM_REQNOTE', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TM_REQNOTE') CREATE  CLUSTERED INDEX IDX_TM_REQNOTE ON T_TM_REQNOTE ( FBILLNO );


 EXEC P_ALTERPK 'PK_TM_REQNOTE_SPOT', 'T_TM_REQNOTE_SPOT', 'FENTRYID', '0';

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


 EXEC P_ALTERPK 'PK_TM_REQNOTE_FWD', 'T_TM_REQNOTE_FWD', 'FENTRYID', '0';

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


 EXEC P_ALTERPK 'PK_TM_REQNOTE_SWAPS', 'T_TM_REQNOTE_SWAPS', 'FENTRYID', '0';

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



/**End D:\PDM_UPGRADE\PDM1\TM_constraint.sql **/