CREATE TABLE Teradatapoint.students ( roll_no INT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 0 MAXVALUE 99999 NO CYCLE), first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, gender CHAR(1) NOT NULL );

as far as i know this is the main way you can follwo this documentation for more

https://www.teradatapoint.com/teradata/teradata-identity-column.htm