MySQL Forums
Forum List  »  InnoDB

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
can´t register more than one FK per table, why?
3925
April 09, 2005 02:51PM


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.