whats wrong with this sql statement?

[ae_jester]

Hi what is wrong with this sql statement?

mySQLstring = "CREATE TABLE Reservations2002 ResNumber LONG CONSTRAINT myconstraint PRIMARY KEY, CustomerID LONG, ReservationDate DATETIME, FreeDay LONG, Status TEXT (50) );"
    mydb.Execute mySQLstring

The above code generates the following error....

"Sytax error in CREATE TABLE statement"