SQL 重置表的id为1

truncate table tablename

delete from tablename

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

posted on 2021-11-05 16:12  快乐鱼  阅读(154)  评论(0编辑  收藏  举报

导航