Who can repair this it really a wizard. I try to add a column to an existing table. It a compound foreign key column from ather two.

ALTER TABLE valoare_lucrari
ADD COLUMN id_oferta 
FOREIGN KEY (id_ofertant, id_proiect)
REFERENCES valoare_lucrari(id_ofertant, id_proiect)

It may be a problem of sintax or even it all idea wrong. But I need to pot in 'id_oferta'
toghether two foreign keys from 'id_ofertant' and 'id_proiect'

Have you tried adding the new field first then coming back and creating the foreign keys? Do any foreign keys exist now?

Yes I tried but nothing happend and the foreign keys exist in the same table

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.