Hi, I'm just starting a web design course (basic) and have to create a database with 2 tables. I have done the the following on the first table, but come up with "syntax error in CREATE TABLE statement". Where have I gone wrong?

CREATE TABLE Employee
(
EMP_ID int PRIMARY KEY,
Location CHAR(255),
FirstName CHAR(255),
Surname CHAR(255);

Do I have spaces where there shouldn't be, for example?

nope, the spaces are okay

the parentheses aren't, however