Data Defintion Query - Creating New AutoNumber Field

You can create a query in the SQL view that adds a new column to a table.
For example, to add a new text field named X10, you use the following
language:

Alter Table MyTargetTable1
Add Column X10 text;

Question: How can I make the new Column X10 be an AutoNumber field. The
following does NOT work:

Alter Table MyTargetTable1
Add Column X10 AutoNumber;

re: Data Defintion Query - Creating New AutoNumber Field

"Mike Wiseley" <mike.wiseley@gte.net> wrote in message
news:j62Ob.4237$ko5.3385@nwrddc01.gnilink.net...[color=blue]
>
> You can create a query in the SQL view that adds a new column to a table.
> For example, to add a new text field named X10, you use the following
> language:
>
> Alter Table MyTargetTable1
> Add Column X10 text;
>
> Question: How can I make the new Column X10 be an AutoNumber field. The
> following does NOT work:
>
> Alter Table MyTargetTable1
> Add Column X10 AutoNumber;[/color]

Change AutoNumber to AutoIncrement