SQL 重置表的id为1

truncate table tablename

或

delete from tablename

DBCC CHECKIDENT ('databasename.dbo.tablename',RESEED, 0)