By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,157 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,157 IT Pros & Developers. It's quick & easy.

Data Defintion Query - Creating New AutoNumber Field

P: n/a

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;


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
rkc

"Mike Wiseley" <mi**********@gte.net> wrote in message
news:j6*****************@nwrddc01.gnilink.net...

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;


Change AutoNumber to AutoIncrement
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.