Data Definition Query Question -- Add New Autonumber Field

I am trying to write a Data Definition type query that will add a new
auto-numbered column to an existing table.

Typically, I would set this up with the following syntax:

"ALTER Table XXX
ADD Column ItemNo Long;"

However, I want the ItemNo to actually be an autonumber Long Integer
field. Any advise on how to change up the SQL for this query would be
appreciated. Thanks.

Michael Wiseley wrote:Replace Long with AutoIncrement