|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 7th, 2004, 02:26 PM
|
|||
|
|||
|
Primary Key
How do I set my Primary Key column auto-increment using Enterprise Manager?
Thanks -D
__________________
Mental Math for Kids of Elementary Grades, Indian Classical Music in Dallas Forthworth, Indian Classical Music in Washington DC region
|
|
#2
December 10th, 2004, 01:12 AM
|
|||
|
|||
|
Hi,
Just open the design table window of the table (right click and select it) and select the field you want to be auto-increment. on the bottom of the page you will see several properties. With SQL Server the auto-increment fields are called identity. Do not ask me why, it just is. So set identity to yes and there you go! Hope it helps, Timo
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Primary Key |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
