CODEWITHSUNDEEP
databasems-access
MoralesJosue
MoralesJosue

Reputation: 199

Create Table in Access with identity value

I want to make a query in witch it creates a simple table, In SQL that would be:

CREATE TABLE RealInventry (ID int IDENTITY(1,1) NOT NULL,PartNumber varchar(255),QTY varchar(255),Locator varchar(255))

I'm trying to do the same it Access DB, but I'm getting an error in "IDENTITY" syntax. How can I make this SQL query work on Access, I'm currently using Access 2013

Any help is appreciated.

Upvotes: 0

Views: 527

Answers (1)

aehiilrs
aehiilrs

Reputation: 1245

Try Autoincrement instead of Identity:

CREATE TABLE test (ID AUTOINCREMENT NOT NULL,PartNumber varchar(255),QTY varchar(255),Locator varchar(255))

Upvotes: 2

Related Questions