title: How Do You Tell What Next Identity Column Will Be?
body: <p>Is there a tsql query to tell what SQL server identity column value it expects to use for the next row insert?</p>
  
  <p><strong>Edited to add:</strong></p>
  
  <p>I deleted and recreated a table with </p>
  
  <pre><code>[personID] [int] IDENTITY(1,1) NOT NULL
  </code></pre>
  
  <p>as part of my CREATE TABLE command.  I've also attempted to reseed identity columns while removing all information in that table and that hasn't always worked.  It got me to wondering if there was a way to see what SQL expected to use for your next identity column number.</p>