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 \n    (
      Column1 INTEGER GENERATED BY DEFAULT AS IDENTITY
         (START WITH 1
          INCREMENT BY 1
          MINVALUE 0\n          MAXVALUE 1000000\n          NO CYCLE
         ),
      Column2 INTEGER);

nVector

posted on