Foreign Key Help

2005-12-22 Thread Jesse
I am trying to add referential integrity to my database. I'm trying to add a foreign key reference to one of my tables, but I'm getting an error when I try to do so. Here's what I'm executing: ALTER TABLE Campers ADD CONSTRAINT FK_Activities FOREIGN KEY FK_Activities (ID) REFERENCES

Re: Foreign Key Help

2005-12-22 Thread SGreen
Jesse [EMAIL PROTECTED] wrote on 12/22/2005 02:51:21 PM: I am trying to add referential integrity to my database. I'm trying to add a foreign key reference to one of my tables, but I'm getting an error when I try to do so. Here's what I'm executing: ALTER TABLE Campers ADD CONSTRAINT

Re: Foreign Key Help

2005-12-22 Thread Jesse
] To: Jesse Cc: mysql@lists.mysql.com Sent: Thursday, December 22, 2005 3:00 PM Subject: Re: Foreign Key Help Jesse [EMAIL PROTECTED] wrote on 12/22/2005 02:51:21 PM: I am trying to add referential integrity to my database. I'm trying to add a foreign key reference to one of my