CREATE TABLE function

Hi I am doing a distance learning course and was asked to create a table within an existing database using these SQL commands;


CREATE TABLE Vehicle (reg_no TEXT(10)

CONSTRAINT VehicleKey PRIMARY KEY,

type TEXT(10),

purchase_date DATETIME,
last_service_date DATETIME, mileage_at_last_service INTEGER);



I was told to save the query and check the new table had the required records in it.



I had huge problems when I tried to save the query and kept getting error messages like:

"query must have at least one destination field" and "syntax error in field destination". This was strange since I was sure I typed the query exactly as it had been written on the worksheet.



Having not changed the SQL command at all it eventually worked when I skipped the 'save query" stage and just went to the "run query" stage. I still don't know why it actually worked in the end and why I kept getting error messages. By running the query am I supposed to just click on "RUN" or can I check the information first by looking at datasheet view? :banghead:

CREATE TABLE function