title: How to generate AUTOMATIC Number in Teradata SQL
body: <p>I want to generate AUTOMATIC Number to use TD SQL, for example as follows,</p>
  
  <pre><code>CREATE MULTISET TABLE TEST_TABLE
  (
    AUTO_NUMBER INT,
    NAME VARCHAR(10)
  )
  PRIMARY INDEX (AUTO_NUMBER);
  
  INSERT INTO TEST_TABLE
  VALUES('TOM');
  INSERT INTO TEST_TABLE
  VALUES('JIM');
  INSERT INTO TEST_TABLE
  VALUES('JAN');
  
  SELECT * FROM TEST_TABLE;
  </code></pre>
  
  <p>The result above will be ,</p>
  
  <pre><code>1 TOM
  2 JIM
  3 JAN
  </code></pre>