Hi,
I have around 10-15 tables that I want to clear.
Is there a quick way (in a script) to have the auto-increment field restart at 1 ?
Thank you.
Printable View
Hi,
I have around 10-15 tables that I want to clear.
Is there a quick way (in a script) to have the auto-increment field restart at 1 ?
Thank you.
DBCC CHECKIDENT ("tablename", RESEED, 1);
Or just truncate the table, that will reset the identities... (but that requires more permissions)