Microsoft Access定义表为什么会显示语法错误

Question

请问用Microsoft Access定义表，为什么会显示语法错误啊？
CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20)
Ssex CHAR(2)
Sage SMALLINT
Sdept CHAR(20)
);

Answer 1

字段间要有逗号间隔

CREATE TABLE Student
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Ssex CHAR(2),
Sage SMALLINT,
Sdept CHAR(20)
);