Auto increment will restart from 1??

Question

suppose a table contains an auto increment column(ABC) and has 20 rows of values.
now I delete all data from the table.

What will be the value of ABC when we insert a new row? will it again start from 1?

Answer 1

Toni Isotalo thanks. can you please see my anther question? I specified it with more details there
https://www.sololearn.com/discuss/1386800/?ref=app

Answer 2

No it continues from the last id. You can recreate the table or use AUTO_INCREMENT = 1 to restart it.

Answer 3

you can use AUTO_INCREMENT=1.
that must work normally

Answer 4

otherwise you can try:

USE «databasename»;
GO

DBCC CHECKIDENT ('«tablename»');
GO

Answer 5

Serigne Fallou DIAGNE thanks. can u please follow the upper link and visit