Create Table Syntax?

Ok I am new to Sql and am wonder How I can (when createing a table ) have a field that is auto incremented.

Here is what I have so far

Code:


CREATE TABLE test (`id` INTEGER NOT NULL, `test` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`)




I want the primary key id to be an incremented number.

I am used to mysql and I would just have the field created as an AUTO_INCREMENT.

Do I use the INCREMENT function within the first query or do I have to have another query that will alter the table and make the field an auto incremented number.

Any suggestions would be great.

Thanks,
Tom