Re: Problems in Foreign Key Syntax

2001-12-24 Thread Patrick Burleson
renced column and referring column > must appear as the first column in an index. > > >I am hoping I am just making some strange mistake. Also of note, I created > >the wishlist table once before without the foreign key constraint and > > dropped it. I have read that there m

Re: Problems in Foreign Key Syntax

2001-12-23 Thread Patrick Burleson
I take out the Foreign Key constraint it creates the wishlish table which leads me to believe this isn't that problem. Thanks, Patrick Burleson Hi!! I am trying create the following tables:- CREATE TABLE Scenario ( Scenario CHAR(10) NOT NULL PRIMARY KEY, CopyFromScenario CHAR(10))