-
autoincrement
Hallo!
I am using a ACCESS datebase and try to create a table with an unique autoincrement column. I habe found many examples for SQLServer, but nor for ACCESS. Does any knows?
Code:
CREATE TABLE myTable (ID integer default autoincrement primary key, name varchar(30))
Does only works in SQLServer.
Please... help me... ;)
Taggi
-
Re: autoincrement
Sometimes ist good to have somebody to spek with. :blush:
OR... to change the words you use in your search... :blush: :D
For ACCESS with C# and SQL-Statement it has to be:
Code:
CREATE TABLE myTable (ID COUNTER primary key, name varchar(30))
:wave: Thanks!