Reset AutoIncrement in SQL Server after Delete

refs:

https://stackoverflow.com/questions/510121/reset-autoincrement-in-sql-server-after-delete

https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql

删除表信息后重置表的自增长id

Sql Server:

DBCC CHECKIDENT (mytable, RESEED, 0)

MySql:

ALTER TABLE tablename AUTO_INCREMENT = 1