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

what database are you using? It may not support foreign key

Sorry for the delay.I am using MySQL

FOREIGN KEY is only valid for InnoDB tables in MySQL I believe