Hi ,
I am trying to add a foreign key in a table, i have written the command to add the key but it doesn't do it.It doens't even display an error.Could you please help me i can't understand what is the problem. This is the command i wrote:
PHP Code:
Alter table Webusers ADD FOREIGN KEY(visitorid)REFERENCES sitevisitors(visitorid);
The table that i am trying to add the foreign key is called "Webusers" with primary key the "userid". The foreign key is the "visitorid" from the table "sitevisitors".
Thank you in advance,
Xenia
|