How-to add autoincrement in Teradata

DROP TABLE MyDb.MyAutoIncrementTable ;

CREATE MULTISET TABLE MyDb.MyAutoIncrementTable
(
ID INTEGER GENERATED BY DEFAULT AS IDENTITY
(START WITH 1
INCREMENT BY 1)
, ColB VARCHAR(20) NOT NULL
)
UNIQUE PRIMARY INDEX INDX_ID (ID);




INSERT INTO MyDb.MyAutoIncrementTable ( ColB ) VALUES ( 'boo' ) ;
INSERT INTO MyDb.MyAutoIncrementTable ( ColB ) VALUES ( 'boo' ) ;
INSERT INTO MyDb.MyAutoIncrementTable ( ColB ) VALUES ( 'boo' ) ;
INSERT INTO MyDb.MyAutoIncrementTable ( ColB ) VALUES ( 'boo' ) ;
INSERT INTO MyDb.MyAutoIncrementTable ( ColB ) VALUES ( 'boo' ) ;
INSERT INTO MyDb.MyAutoIncrementTable ( ColB ) VALUES ( 'boo' ) ;
INSERT INTO MyDb.MyAutoIncrementTable ( ColB ) VALUES ( 'boo' ) ;


SELECT * FROM MyDb.MyAutoIncrementTable ;