|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
|
|
|
|