Data Definition Query Question -- Add New Autonumber Field

#1 July 18th, 2006, 01:15 AM

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.

#2 July 18th, 2006, 02:05 AM

Michael Wiseley wrote:

Quote:

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.

Replace Long with AutoIncrement

Data Definition Query Question -- Add New Autonumber Field

re: Data Definition Query Question -- Add New Autonumber Field

/bytes/development

/bytes/it

/bytes/about