[SQL] AUTOINCREMENT--help

[Macky]

Is there a function in SQL that does autoincrementing...

eg.

CREATE TABLE (name varchar(40),num_id int);

wherein num_id starts with 0 and then when ever I INSERT another record
num_id goes 1 etc....

Thanks in advance............