Does anyone know how to use SQL command to Create/Alter Table with autonumber column? I was looking for field data type for Access DataBase from msdn online help, and wondering there is no auto number data type.

My SQL command is like:
CREATE TABLE pTable(Column1 integer)

and Column1 field will be long integer data type, how can I make it as autonumber data type?

Thanks in advance!!

Wenjung Lin