none
How to define constraint? RRS feed

  • Question

  • CREATE TABLE Orders 
    (
    OrderId INTEGER PRIMARY KEY, 
    CustId INTEGER, 
    OrderNotes varCHAR, 
    CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId) REFERENCES Customers 
    ON UPDATE SET NULL ON DELETE SET NULL
    );

    I receive message that i have syntax error in UPDATE, why?

    Monday, May 30, 2016 8:45 AM

Answers

All replies