title: Autoincrement ID java db
body: <p>I have such a problem.</p>
  
  <p>I have in my database 10 students.
  When I removed from a database student with ID 2 and I want to add a new student with ID 2,which will replace the earlier removed student, it gets ID 11 , no 2. </p>
  
  <p>I use script </p>
  
  <pre><code>CREATE TABLE student (
      id_student INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), ......
  </code></pre>
  
  <p>I use Java DB.</p>
  
  <p>Is there any script which is able to solve this my problem?</p>