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