EXEC P_ALTERPK 'PK_PUR_SUPPLIERCOLLINFO', 'T_PUR_SUPPLIERCOLLINFO', 'FID', '1';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PUR_SCI_FSUPPLIERID') CREATE UNIQUE INDEX IDX_PUR_SCI_FSUPPLIERID ON T_PUR_SUPPLIERCOLLINFO ( FSUPPLIERID );

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PUR_SCI_FNUMBER') CREATE INDEX IDX_PUR_SCI_FNUMBER ON T_PUR_SUPPLIERCOLLINFO ( FNUMBER );