/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_constraint.sql **/
 EXEC P_ALTERPK 'PK_TCCIT_DG_A100000_1', 'T_TCCIT_DG_A100000_1', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A100000_1') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A100000_1 ON T_TCCIT_DG_A100000_1 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A100000_2', 'T_TCCIT_DG_A100000_2', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A100000_2') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A100000_2 ON T_TCCIT_DG_A100000_2 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A100000_3', 'T_TCCIT_DG_A100000_3', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A100000_3') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A100000_3 ON T_TCCIT_DG_A100000_3 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A101010', 'T_TCCIT_DG_A101010', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A101010') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A101010 ON T_TCCIT_DG_A101010 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A101020', 'T_TCCIT_DG_A101020', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A101020') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A101020 ON T_TCCIT_DG_A101020 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A102010', 'T_TCCIT_DG_A102010', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A102010') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A102010 ON T_TCCIT_DG_A102010 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A102020', 'T_TCCIT_DG_A102020', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A102020') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A102020 ON T_TCCIT_DG_A102020 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A103000', 'T_TCCIT_DG_A103000', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A103000') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A103000 ON T_TCCIT_DG_A103000 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A104000', 'T_TCCIT_DG_A104000', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A104000') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A104000 ON T_TCCIT_DG_A104000 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_A105000_2', 'T_TCCIT_DG_A105000_2', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_A105000_2') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_A105000_2 ON T_TCCIT_DG_A105000_2 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105014_1', 'T_TCCIT_DG_B105014_1', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105014_1') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105014_1 ON T_TCCIT_DG_B105014_1 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105014_2', 'T_TCCIT_DG_B105014_2', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105014_2') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105014_2 ON T_TCCIT_DG_B105014_2 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105014_3', 'T_TCCIT_DG_B105014_3', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105014_3') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105014_3 ON T_TCCIT_DG_B105014_3 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105015', 'T_TCCIT_DG_B105015', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105015') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105015 ON T_TCCIT_DG_B105015 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105016', 'T_TCCIT_DG_B105016', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105016') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105016 ON T_TCCIT_DG_B105016 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105017', 'T_TCCIT_DG_B105017', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105017') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105017 ON T_TCCIT_DG_B105017 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105018', 'T_TCCIT_DG_B105018', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105018') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105018 ON T_TCCIT_DG_B105018 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105023_1', 'T_TCCIT_DG_B105023_1', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105023_1') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105023_1 ON T_TCCIT_DG_B105023_1 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105023_2', 'T_TCCIT_DG_B105023_2', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_DG_B105023_2') CREATE  CLUSTERED INDEX IDX_TCCIT_DG_B105023_2 ON T_TCCIT_DG_B105023_2 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107041', 'T_TCCIT_QYSDS_A107041', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_QYSDS_A107041') CREATE  CLUSTERED INDEX IDX_TCCIT_QYSDS_A107041 ON T_TCCIT_QYSDS_A107041 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107042', 'T_TCCIT_QYSDS_A107042', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_QYSDS_A107042') CREATE  CLUSTERED INDEX IDX_TCCIT_QYSDS_A107042 ON T_TCCIT_QYSDS_A107042 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A000000', 'T_TCCIT_QYSDS_A000000', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_QYSDS_A000000') CREATE  CLUSTERED INDEX IDX_TCCIT_QYSDS_A000000 ON T_TCCIT_QYSDS_A000000 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_APITUDEINFO', 'T_TCCIT_APITUDEINFO', 'FENTRYID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_SURE_DECLARE', 'T_TCCIT_SURE_DECLARE', 'FENTRYID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_POLICY', 'T_TCCIT_POLICY', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_POLICY') CREATE  CLUSTERED INDEX IDX_TCCIT_POLICY ON T_TCCIT_POLICY ( FORGID );



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