Create a table in query plan

perspolis

Guest

Posts: n/a

29th Dec 2006

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

« Date formatting | QUICKBOOKS or ACCESS? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create join between 3 tables, query table 1 results table 3	=?Utf-8?B?c2ltb24=?=	Microsoft Access Queries	2	5th Oct 2007 01:57 PM
Using the current open query or table to create new query	=?Utf-8?B?Y2hvb3NldG9sYXVnaA==?=	Microsoft Access Queries	0	31st Aug 2007 08:02 PM
To have month and year as part of the table name in CREATE TABLE or MAKE TABLE Query	ichew@scs.com.sg	Microsoft Access Getting Started	1	18th Apr 2006 06:38 AM
Create Table Primary Key after Make Table Query And Update Table	=?Utf-8?B?Uk5VU1pAT0tEUFM=?=	Microsoft Access Queries	1	3rd May 2005 08:07 PM
Re: Table Plan Query	Cameo	Microsoft Access	7	15th Sep 2003 08:19 AM