CREATE TABLE invoption
(
saleinv CHAR(6) CONSTRAINT nn_invoption_saleinv NOT NULL
CONSTRAINT fk_invoption_saleinv REFERENCES saleinv (saleinv),
ocode CHAR(4) CONSTRAINT nn_invoption_ocode NOT NULL
CONSTRAINT fk_invoption_ocode REFERENCES options (ocode),
saleprice NUMBER(7,2) CONSTRAINT nn_invoption_saleprice NOT NULL,
UNIQUE (saleinv, ocode)
);
Create constraint
Page 1 of 11 Replies - 1679 Views - Last Post: 21 January 2013 - 09:18 PM
#1
Create constraint
Posted 21 January 2013 - 06:13 PM
how can use constraint in last line of this code, I has composite primary key their
Replies To: Create constraint
#2
Re: Create constraint
Posted 21 January 2013 - 09:18 PM
What do you mean by your question? Can you please elaborate on what exactly you want to ask?
regards,
Raghav
regards,
Raghav
Page 1 of 1
|
|

New Topic/Question
Reply


MultiQuote



|