title: How to reset auto-increment in SQL Server?
body: <p>I've been having this problem with my database where it kept on incrementing the id column even though it has been removed. To better understand what I meant, here is a screenshot of my gridview:</p>
  
  <p><a href="https://i.stack.imgur.com/1lHgo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1lHgo.png" alt="enter image description here"></a></p>
  
  <p>As you can see from the id column, everything is fine from 11 - 16. but it suddenly skipped from 25 - 27. 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.</p>
  
  <p>Here is also part of the SQL script:</p>
  
  <pre><code>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)
   ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
   GO
  
   SET ANSI_PADDING OFF
   GO
  </code></pre>