Link to home
Create AccountLog in
Avatar of joeyc801
joeyc801

asked on

CREATE TABLE commands with access

My teacher is driving me nuts with SQL and Access, I am convinced he is teaching us the wrong way. Any way I cannot get CREATE TABLE to work for access 2010, it keeps coming syntax error. Please help!!
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Post the syntax you created so we can see what's wrong.
Avatar of joeyc801
joeyc801

ASKER

CREATE TABLE Movies(
Title VARCHAR(20) PRIMARY KEY,
Year SMALLINT CHECK (Year>1900 AND Year<2010),
Runtime SMALLINT,
Rating NUMBER CHECK (Rating >= 0 AND Rating <= 10)
)
I get a syntax error with this code.
Look at difference data types, differences between Access and SQL Server.
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account