Create table statement syntax error in access 2000

T

tonyck

Joined
Jun 30, 2005
Messages
59
Reaction score
0
Hi guys i tried to run this create table statement and each time i get syntax error.
I pasted the code in sql view windows of access 2000 and pressed the run code and i get
this error massage saying there is syntax error. Could any one help me write correct
create table statement that does not give me this error.I know u might tell me why u
do not create table in design view or .. but i want to do this since i want learn this
method as well.thanks


Code: 
CREATE TABLE PLAYERS
(PLAYERNO SMALLINT NOT NULL  CHECK (PLAYERNO >0),
NAME CHAR(25) NOT NULL ,
INITIALS CHAR(5) NOT NULL ,
BIRTH_DATE DATETIME,
SEX CHAR(1) NOT NULL ,
JOINED SMALLINT CHECK (JOINED >=1980),
STREET CHAR(15) NOT NULL ,
HOUSENO CHAR(4),
POSTCODE CHAR(6),
TOWN CHAR(10) NOT NULL ,
PHONENO CHAR(10),
LEAGUENO CHAR(4),
PRIMARY KEY (PLAYERNO)
)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referential Integrity in CREATE TABLE command 6
MS-SQL AND ACCESS LINKED TABLE PROBLEM (#ERROR FIELDS) (cross) 1
create access table w/primary key 1
not receiving records in ADP 2
How do I set Unicode Compression to yes in create table statement? 3
Setting Defaults in Create table statement? 1
Syntax error in CREATE TABLE statement. (Error 3290) 3
Syntax Error in field definition 6

Top