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

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_ZB', 'T_TCCIT_QYSDS_ZB', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_WGQYXX', 'T_TCCIT_QYSDS_WGQYXX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_SGGFXX', 'T_TCCIT_QYSDS_SGGFXX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_JMSDSYH', 'T_TCCIT_QYSDS_JMSDSYH', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_GDZCZJYHMX', 'T_TCCIT_QYSDS_GDZCZJYHMX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_GDXX', 'T_TCCIT_QYSDS_GDXX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_FZJGXX', 'T_TCCIT_QYSDS_FZJGXX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_DYNSBAB', 'T_TCCIT_QYSDS_DYNSBAB', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_CZGFXX', 'T_TCCIT_QYSDS_CZGFXX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A109010_ZJG', 'T_TCCIT_QYSDS_A109010_ZJG', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A108030', 'T_TCCIT_QYSDS_A108030', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A108020', 'T_TCCIT_QYSDS_A108020', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A108010', 'T_TCCIT_QYSDS_A108010', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A108000', 'T_TCCIT_QYSDS_A108000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107050', 'T_TCCIT_QYSDS_A107050', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107040', 'T_TCCIT_QYSDS_A107040', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107030', 'T_TCCIT_QYSDS_A107030', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107020', 'T_TCCIT_QYSDS_A107020', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107012_MX', 'T_TCCIT_QYSDS_A107012_MX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107012_JB', 'T_TCCIT_QYSDS_A107012_JB', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107011', 'T_TCCIT_QYSDS_A107011', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107010', 'T_TCCIT_QYSDS_A107010', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A106000', 'T_TCCIT_QYSDS_A106000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105120', 'T_TCCIT_QYSDS_A105120', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105110', 'T_TCCIT_QYSDS_A105110', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105100', 'T_TCCIT_QYSDS_A105100', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105090', 'T_TCCIT_QYSDS_A105090', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105080', 'T_TCCIT_QYSDS_A105080', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105070', 'T_TCCIT_QYSDS_A105070', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105060', 'T_TCCIT_QYSDS_A105060', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105050', 'T_TCCIT_QYSDS_A105050', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105040', 'T_TCCIT_QYSDS_A105040', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105030', 'T_TCCIT_QYSDS_A105030', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105020', 'T_TCCIT_QYSDS_A105020', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105010', 'T_TCCIT_QYSDS_A105010', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A105000', 'T_TCCIT_QYSDS_A105000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A104000', 'T_TCCIT_QYSDS_A104000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A103000', 'T_TCCIT_QYSDS_A103000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A102020', 'T_TCCIT_QYSDS_A102020', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A102010', 'T_TCCIT_QYSDS_A102010', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A101020', 'T_TCCIT_QYSDS_A101020', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A101010', 'T_TCCIT_QYSDS_A101010', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A100000', 'T_TCCIT_QYSDS_A100000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_MSYHMX', 'T_TCCIT_QYSDS_MSYHMX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_DSXX', 'T_TCCIT_QYSDS_DSXX', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A109010_FZ', 'T_TCCIT_QYSDS_A109010_FZ', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A109000', 'T_TCCIT_QYSDS_A109000', 'FID', '0';

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



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