My problems with adding constraints using the Tryit editor continue ...
Adding a table with...
CREATE TABLE PersonTest(PersonID int PRIMARY KEY,Name varchar(255))
no problem, but then subsequently adding another table...
CREATE TABLE OrderTest(OrderID int PRIMARY KEY,OrderDesc varchar(255),PersonID int FOREIGN KEY REFERENCES PersonTest(PersonID))
Gives me a similar "Error 1: could not prepare statement (1 near "FOREIGN"; syntax error)".
The course content becomes hard to test this way