Identity column in Teradata

Identity columns are used mainly to ensure row uniqueness by taking a system-generated unique value. They are valuable for generating simple unique indexes and primary and surrogate keys when composite indexes or keys are not desired

    CREATE MULTISET TABLE test01 
    (
      Column1 INTEGER GENERATED BY DEFAULT AS IDENTITY
         (START WITH 1
          INCREMENT BY 1
          MINVALUE 0
          MAXVALUE 1000000
          NO CYCLE
         ),
      Column2 INTEGER);

nVector

posted on 26 May 18