|"on delete cascade" results in syntax error (Derby) [message #588290]
||Fri, 26 October 2007 16:39
if I run the following SQL statement I receive in the SQL Result view the
message:Syntax error: Encountered ";" at line 183, column 2.
I used to use this statement to create the database in Derby. Can you tell
me what is wrong with the statement?
Best regards, Lars
create table sixsigma.rel_req_user(
req_id int not null,
user_id int not null,
primary key (req_id,user_id),
foreign key(req_id) references sixsigma.requirement(req_id) on delete
foreign key(user_id) references sixsigma.users(id) on delete cascade
Powered by FUDForum
. Page generated in 0.03410 seconds