Luis Asked: 2022-09-10 09:09:50 +0800 CST 2022-09-10 09:09:50 +0800 CST 2022-09-10 09:09:50 +0800 CST How to restart numbering of an id that is going to enter a table 772 I have a table where in each record that I enter, an id is added, but when I delete an id and when I want to add another, it does not restart. sql 1 Answers Voted Best Answer Osaskoh 2022-09-10T09:15:16+08:002022-09-10T09:15:16+08:00 what you need is the following script: DBCC CHECKIDENT('Plantillaid' , RESEED, 0) where is the 0 you can modify so that it resets to the value that you say
what you need is the following script:
where is the 0 you can modify so that it resets to the value that you say