Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » "on delete cascade" results in syntax error (Derby)
"on delete cascade" results in syntax error (Derby) [message #588290] Fri, 26 October 2007 16:39
Lars Vogel - out of office until 16.03.2020 is currently offline Lars Vogel - out of office until 16.03.2020Friend
Messages: 1094
Registered: July 2009
Senior Member


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

Previous Topic:Problem with sqlmodel.ecore
Next Topic:"on delete cascade" results in syntax error (Derby)
Goto Forum:

Current Time: Wed Nov 25 21:00:44 GMT 2020

Powered by FUDForum. Page generated in 0.02103 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top