title: Auto increment feature in Database
body: <p>I use SQL Server and when I create a new table I make a specific field an auto increment
  primary key. The problem is some people told me making the field an auto increment for the primary key means when deleting any record (they don't care about the auto increment field number) the field increases so at some point - if the type of my field is integer for example - the range of integer will be consumed totally and i will be in trouble. So they tell me not to use this feature any more.</p>
  
  <p>The best solution is making this through the code by getting the max of my primary key then if the value does not exist the max will be <code>1</code> other wise <code>max + 1</code>.</p>
  
  <p>Any suggestions about this problem? Can I use the auto increment feature?</p>
  
  <p>I want also to know the cases which are not preferable to use auto increment ..and the alternatives...</p>
  
  <p>note :: this question is general not specific to any DBMS , i wanna to know is this true also for DBMSs like ORACLE ,Mysql,INFORMIX,....</p>
  
  <p>Thanks so much.</p>