Create a table in query plan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top