Primary Key AutoNumber Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

a - 13 Mar 2008 05:51 GMT

How can I create Primary Key autonumber field by SQL Command?
For existing data start from 1 and end at the end of rows
Example:
Field Name : Id Auto Number (Primary Key)
Id Name
1 a
2 b
3 c
and so on
thank you

Reply to this Message

MGFoster - 13 Mar 2008 07:44 GMT

> How can I create Primary Key autonumber field by SQL Command?
> For existing data start from 1 and end at the end of rows
[quoted text clipped - 6 lines]
> and so on
> thank you

If you have an existing table (TableA), like this:

ALTER TABLE TableA ADD COLUMN Id COUNTER PRIMARY KEY;

If you don't have the table, like this:

CREATE TABLE TableA (
Id COUNTER PRIMARY KEY,
Name, Text(1) NOT NULL
);

In the JET db (Access) the "Counter" data type is the AutoNumber data
type. If you are using SQL Server as your back-end, substitute
IDENTITY(1,1) for COUNTER.

You can run both DDL statements from the SQL view of a QueryDef.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

Reply to this Message