-
Syntax error in CONSTRAINT
I to everybody!
I created a query like this in Access:
ALTER TABLE Ordini
ADD CONSTRAINT FKOrdiniIdCliente
FOREIGN KEY (IdCliente) REFERENCES tm_Cicli (ProductID)
It works rightly!
If I add two more commands
ALTER TABLE Ordini
ADD CONSTRAINT FKOrdiniIdCliente
FOREIGN KEY (IdCliente) REFERENCES tm_Cicli (ProductID)
ON UPDATE CASCADE
ON DELETE CASCADE
I receive a syntax error:
"Syntax error in CONSTRAINT"
Does anybody know why?
Thank you very much!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|