Can anyone tell me how to create a primary key on two fields?
I have a table called "fmrDocs". It has two numeric fields called "fmrItemId" and "ptChgNumber". Both of those values are required to uniquely identify the record.
I have tried to list the two fields separated by a comma in the
ALTER TABLE fmrDocs
ADD CONSTRAINT fmrDocs_fmrItemId_pk PRIMARY KEY
(fmrItemId, ptChgNumber). That didn't work.
I tried ALTER TABLE fmrDocs
ADD CONSTRAINT fmrDocs_fmrItemId_pk PRIMARY KEY
(fmrItemId||ptChgNumber). That didn't work.
Our dba is out sick and I have to finish this very soon. Thanks in advance.
Fran
I have a table called "fmrDocs". It has two numeric fields called "fmrItemId" and "ptChgNumber". Both of those values are required to uniquely identify the record.
I have tried to list the two fields separated by a comma in the
ALTER TABLE fmrDocs
ADD CONSTRAINT fmrDocs_fmrItemId_pk PRIMARY KEY
(fmrItemId, ptChgNumber). That didn't work.
I tried ALTER TABLE fmrDocs
ADD CONSTRAINT fmrDocs_fmrItemId_pk PRIMARY KEY
(fmrItemId||ptChgNumber). That didn't work.
Our dba is out sick and I have to finish this very soon. Thanks in advance.
Fran