IDENTITY

  • Thread starter Thread starter Man Utd
  • Start date Start date
M

Man Utd

CREATE TABLE [Categories]
([Categories ID] INTEGER IDENTITY,
[Title] TEXT(30),
[System] LOGICAL
)

I got a syntax error when try to save this query in Access 2003.
 
Man Utd said:
CREATE TABLE [Categories]
([Categories ID] INTEGER IDENTITY,
[Title] TEXT(30),
[System] LOGICAL
)
I got a syntax error when try to save this query in Access 2003.
Click to expand...

Hello "Man Utd".
Try the following:
CREATE TABLE [Categories]
( [Categories ID] AUTOINCREMENT,
[Title] TEXT(30),
[System] LOGICAL)
 
Back
Top