Skip to primary content

Phaisarn

Phaisarn

Main menu

  • Home
  • Azure

Post navigation

← Previous Next →

MS SQL Server

Posted on March 19, 2020 by jack

Reset identity seed after deleting records in SQL Server

  • stackoverflow.com
  • DBCC CHECKIDENT (Transact-SQL)

คือลบ record แล้ว และอยากให้ reset ค่า id ให้ใช้คำสั่ง

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

This entry was posted in SQL Server by jack. Bookmark the permalink.
Proudly powered by WordPress