wrong sintax at line 1

[cristi08]

what is wrong here?

ALTER TABLE valoare_lucrari(
ADD CONSTRAINT fk_oferta
FOREIGN KEY (id_ofertant,id_proiect)references(id_ofertant,id_proiect))

[Karthik.gautham]

you have not closed the braces properly

[cristi08]

I can not see that.

[cristi08]

I removed the first brace but know It tell me that I have a sintax error at line 3

[cristi08]

ALTER TABLE valoare_lucrari
ADD CONSTRAINT fk_oferta
FOREIGN KEY (id_ofertant,id_proiect)references(id_ofertant,id_proiect)

[Karthik.gautham]

after 'ALTER TABLE valoare_lucrari' you have opened a beace '(' but you din't close it.

[Karthik.gautham]

ALTER TABLE valoare_lucrari(
ADD CONSTRAINT fk_oferta
FOREIGN KEY (id_ofertant,id_proiect)references(id_ofertant,id_proiect))

[Karthik.gautham]

use the above query

[cristi08]

this problem is solved but the command did not altered table at all

]ALTER TABLE valoare_lucrari
ADD CONSTRAINT fk_oferta
FOREIGN KEY (id_ofertant,id_proiect)references valoare_lucrari(id_ofertant,id_proiect)

[Karthik.gautham]

syntax:

ALTER TABLE valoare_lucrari(
ADD CONSTRAINT fk_oferta
FOREIGN KEY ('you need to spicify only one fiedd') references valoare_lucrari('target_field')

[Karthik.gautham]

add one more ')' at the end

[cristi08]

but I have two columns from I wish to establish a composite foreign key

[cristi08]

with this

ALTER TABLE valoare_lucrari
ADD CONSTRAINT id_oferta
FOREIGN KEY (id_ofertant,id_proiect)references valoare_lucrari(id_ofertant,id_proiect)

it sais" your query executed ok ",
but no modification in the 'valoare_lucrari' table
do you know how can I generate a composite foreign key ?