title: Restart AUTO_INCREMENT field in delphi
body: <p>I'm using firebird database and trying to restart id column as <em>AUTO_INCREMENT</em></p>
  
  <p>field after DELETE
  like the following code:</p>
  
  <pre><code>  SQLQuery1.Close;
    SQLQuery1.SQL.Text :='DELETE FROM MY_TABLE';
    SQLQuery1.ExecSQL;
    //---------------------------------------------------------
    SQLQuery1.Close;
    SQLQuery1.SQL.Text :=
      'ALTER TABLE MY_TABLE ALTER COLUMN ID AUTO_INCREMENT =1';
    SQLQuery1.ExecSQL;
  </code></pre>
  
  <p>But I cannot do that. Only DELETE SQL command works.
  And how TRUNCATE works?
  The following code not works in delphi too:</p>
  
  <pre><code>  SQLQuery1.Close;
    SQLQuery1.SQL.Text :=
      'TRUNCATE TABLE MY_TABLE';
    SQLQuery1.ExecSQL;
  </code></pre>
  
  <p>Thank you</p>