CODEWITHSUNDEEP
databasems-access
raaz
raaz

Reputation: 12500

Reset identity column in MS access database

Currently i am trying to reset an identity column in my MS access database by using following command but it is not working.

DBCC CHECKIDENT('my_table', RESEED, 1)

Error Message :

Invalid SQL Statement ; expected "Delete","insert","procedure","select" or "update"

How to fix it ?

Upvotes: 1

Views: 5405

Answers (1)

Luke Wage
Luke Wage

Reputation: 703

CHECKIDENT works on SQL Server only. Here is a link to an explanation how to do it in Access: How to restart counting from 1 after erasing table in MS Access?

Upvotes: 2

Related Questions