DROP TABLE test_tbl; CREATE TABLE test_tbl ( ID INTEGER GENERATED ALWAYS AS IDENTITY, name CHAR(12) PRIMARY KEY ); INSERT INTO test_tbl( name ) VALUES( 'Poke Mon' ); INSERT INTO test_tbl( name ) VALUES( 'Digi Mon' ); INSERT INTO test_tbl( name ) VALUES( 'Sponge Bob' ); INSERT INTO test_tbl( name ) VALUES( 'Super Mario' ); INSERT INTO test_tbl( name ) VALUES( 'Luigi' ); COMMIT;