can´t register more than one FK per table, why?
Posted by:
João Galli
Date: April 09, 2005 02:51PM
HI,
well, I have a table that has 4 FKs
but I can´t link it to more than 1 table...
this is my sql:
ALTER TABLE `topassist`.`ordem_servico` ADD CONSTRAINT `FK_ordem_servico_pessoa` FOREIGN KEY `FK_ordem_servico_pessoa` (`pessoa_fk`)
REFERENCES `pessoa` (`id`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
ADD CONSTRAINT `FK_ordem_servico_tecnico` FOREIGN KEY `FK_ordem_servico_tecnico` (`tecnico_fk`)
REFERENCES `tecnico` (`id`)
ON DELETE RESTRICT
ON UPDATE RESTRICT;
CAN IT BE DONE?
Subject
Views
Written By
Posted
can´t register more than one FK per table, why?
3953
April 09, 2005 02:51PM
2262
April 11, 2005 08:51AM
2281
April 11, 2005 01:11PM
2111
April 11, 2005 10:42PM
2180
April 13, 2005 06:59PM
2132
April 14, 2005 11:05PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.