P
perspolis
Hi all
I want to create a table which has some constraints with query..my sample is
below:
CREATE TABLE Customers (CustId INTEGER PRIMARY KEY, CLstNm text (50))
CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, OrderNotes
text, CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId) REFERENCES Customers ON
UPDATE CASCADE )
but it gives me error on syntax of Constraints..
thanks in advance
I want to create a table which has some constraints with query..my sample is
below:
CREATE TABLE Customers (CustId INTEGER PRIMARY KEY, CLstNm text (50))
CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, OrderNotes
text, CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId) REFERENCES Customers ON
UPDATE CASCADE )
but it gives me error on syntax of Constraints..
thanks in advance