How to update seed and increment parameters of a identity parameter?

Question

How do I alter the column for changing the seed and increment values of a table after truncating the table.

I have created a table named table and inserted few rows into that table then I have truncated that table and want to update the seed and increment values of identity column.

How can I do this?

Possible duplicate of [Reset identity seed after deleting records in SQL Server](https://stackoverflow.com/questions/21824478/reset-identity-seed-after-deleting-records-in-sql-server) — Michał Turczyn, Nov 20 '17 at 06:27
@SohelAhmed `TRUNCATE` will automatically reseed the identity column. So you don't have to manually do it. — Jibin Balachandran, Nov 20 '17 at 06:28

score 1 · Accepted Answer · answered Nov 20 '17 at 06:28

1

DBCC CHECKIDENT ('Table', RESEED, 0);

answered Nov 20 '17 at 06:28

Mike

721
7
13

4

`TRUNCATE` will automatically reseed the identity column. It's needed only for `DELETE` – Jibin Balachandran Nov 20 '17 at 06:29

How to update seed and increment parameters of a identity parameter?

1 Answers1