changing column to autonumber

  • Thread starter Thread starter Konrad
  • Start date Start date
K

Konrad

Hi

How to change programatically column
from primary key to
autonumber?

Thanks
Konrad
 
Konrad,

Look at the AutoIncrement, AutoIncrementStep and AutoIncrementSeed
properties of DataColumn

Stephen
 
Konrad,

Sorry, I assumed you meant a DataSet
If its a SQLServer database (or MSDE), you can use ALTER TABLE to make
changes to a table
Refer to SQL Server Books Online for help on this

Stephen
 
Mainly I'am interested in Access database.
I read from sites that this is impossible.
Is it true?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force Autonumber to generate 0
installing stored procedure programatically 1
relationship 2
Detect autonumbered field in MS Access 6
Add primary key 5
Access 2010 query for 3 tables 0
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Creating a key consisting of two columns 1

Back
Top