如何在MSSQL中重置自动增量？

我一直在使用我的数据库这个问题，即使它已被删除，它仍然会增加id列。让我说我有一个从1到16的id列。现在我想添加一个项目，它的ID将是17.但当我删除项目17并决定再次添加项目时，它将进入18.所以现在我的id列将类似于1-16和18。它在我的id列中创建了这个巨大的差距，因为它继续自动递增id列。我想要发生的是，当我删除一个项目时，我希望它从最后一个16开始。所以下一个id应该是17.我希望这对你们有意义。



我尝试过：



这是sqp脚本的一部分：

I've been having this problem with my database where it kept on incrementing the id column even though it has been removed. Lets say i have an id column from 1 - 16. Now i want to add an item, its id will be 17. But when i remove item 17 and decided to add an item again, it will proceed to 18. So now my id column would be like from 1-16&18. Its creating this huge gap in my id column because of its continued auto-incrementing the id column. What i want to happen is, when i remove an item, i want it to start from the last id which is 16. So the next id should be 17. I hope this makes sense for you guys.

What I have tried:

Here is the part of the sqp script:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guitarItems](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[type] [varchar](50) NOT NULL,
	[brand] [varchar](50) NOT NULL,
	[model] [varchar](50) NOT NULL,
	[price] [float] NOT NULL,
	[itemimage1] [varchar](255) NULL,
	[itemimage2] [varchar](255) NULL,
	[description] [text] NOT NULL,
	[necktype] [varchar](100) NOT NULL,
	[body] [varchar](100) NOT NULL,
	[fretboard] [varchar](100) NOT NULL,
	[fret] [varchar](50) NOT NULL,
	[bridge] [varchar](100) NOT NULL,
	[neckpickup] [varchar](100) NOT NULL,
	[bridgepickup] [varchar](100) NOT NULL,
	[hardwarecolor] [varchar](50) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[guitarItems] ON