Future minutes - Technology Trends – Technology guidelines – Technology assitance

Reset identity seed records in SQL Server Ask Question

By Junaid A 17-Nov-2024 1

How to Reset identity seed records in SQL Server?

Option1

DBCC CHECKIDENT ('[YourTableName]', RESEED, 0);
GO

Option 2

DBCC CHECKIDENT ('NameofYourTable', RESEED, 0)
GO

'Option 3

DELETE FROM [MyTable];
DBCC CHECKIDENT ('[MyTable]', RESEED, 0);

Solutions

Junaid A

i really need this solution thanks

10318

For Submision Log in first

Copyright Future Minutes © 2015- 2024 All Rights Reserved. Terms of Service | Privacy Policy | Contact US| Pages| Whats new?

Update on: Dec 20 2023 05:10 PM

Messages
Notifications

messages

Ibrahim Ahmed Helo dear i wanna talk to you
Fatima J. Helo dear i wanna talk to you
Fawad Ahmed Helo dear i wanna talk to you
Saim Turan Helo dear i wanna talk to you
Alis wells Helo dear i wanna talk to you

view all

notifications

Alis wells recommend your post
Alis wells share your post a good time today!
Alis wells recommend your post
Alis wells share your post a good time today!
Alis wells recommend your post

view all