Eclipse Community Forums: DTP » "on delete cascade" results in syntax error (Derby)

Help

Home

Home » Eclipse Projects » DTP » "on delete cascade" results in syntax error (Derby)

Show: Today's Messages :: Show Polls :: Message Navigator

"on delete cascade" results in syntax error (Derby) [message #588290]

Fri, 26 October 2007 16:39

Lars Vogel

Messages: 1098
Registered: July 2009

Senior Member

Hi,

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
cascade,

foreign key(user_id) references sixsigma.users(id) on delete cascade

);

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:22:37 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter