Re: Data Definition Query Question -- Add New Autonumber Field
- From: rkc <rkc@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 18 Jul 2006 01:06:15 GMT
Michael Wiseley wrote:
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
.
- References:
- Data Definition Query Question -- Add New Autonumber Field
- From: Michael Wiseley
- Data Definition Query Question -- Add New Autonumber Field
- Prev by Date: Re: Subform Acting Weird (again...)
- Next by Date: Re: Passing fieldname to a subroutine
- Previous by thread: Data Definition Query Question -- Add New Autonumber Field
- Index(es):
