Identity Columns

You can generate ID values using identity columns. These are similar to default values, but are dynamically evaluated.

Example
CREATE TABLE actors (id INTEGER IDENTITY,
              lastname VARCHAR(20),
              surname VARCHAR(20));

INSERT INTO actors (lastname, surname) VALUES
                    ('Pacino', 'Al'),
                    ('Willis', 'Bruce'),
                    ('Pitt', 'Brad');

SELECT * FROM actors;
Results
id lastname surname
1 Pacino Al
2 Willis Bruce
3 Pitt Brad