Primary Key AutoNumber Field

[MGFoster]

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

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

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR9jNRoechKqOuFEgEQKW5QCg0KES8v0nCOwsmqMzPDUC5Ii4ryAAn2Oy
f/Nq7qajlYDhxg6F714MqX+W
=pRK3
-----END PGP SIGNATURE-----

 

[a]

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