title: How to know the next value of an automatically incremented primary key if all rows were deleted from a table?
body: <p>There is a table which had records but these records were deleted. There is a primary key which is incremented automatically on the database table.</p>
  
  <p>Is there a way to know , before inserting a new row in the table , the next value of this primary key ? If it is not possible is there a way to get the immediately the value of the generated primary key after inserting a row ?</p>