FOREIGN KEY ... ON DELETE CASCADE - syntax error

FOREIGN KEY ... ON DELETE CASCADE - syntax error

Post by trun.. » Tue, 11 Sep 2001 23:55:31



I am using Microsoft Access 2000 with
"Microsoft Access Driver (*.mdb)" version 4.00.5303.01

I executed following SQL statement:

CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER,
CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId) REFERENCES Customers)

Everything was ok, table was created than I executed the same statement
with "ON DELETE CASCADE" at the end:

CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER,
CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId) REFERENCES Customers ON DELETE
CASCADE)

I got following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in CONSTRAINT clause.

Can somebody help me?
Is there any tool which says me where exactly the the syntax error is?

Thank you
Jiri Trunkat