alter table LOGIN_SPONSOR ADD constraint FK_LOGIN_SPONSOR_PART_LOGIN_MASTER FOREIGN KEY (LOGIN_ID) references LOGIN_MASTER (ID) on delete cascade<BR><BR>whats wrong with this.<BR><BR>
There is no syntactical error in the statement. What's the problem? Error message?
It says "incorrect syntax near ON"
Which DBMS are you using?
I am using MS SQL SERVER 7.0