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