M
MGFoster
a said: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-----