|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Reg. identity column seed value
Hi,
I have a table for which the primary key is an identity column. Let us say there are 100 records in the table. Now I want some gap in the primary key values. Can I set the identity seed on the primary key to start at a higher value, say 500 (leaving the values 101 to 499 unused for the primary key column)? Thanks in advance ourspt |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Reg. identity column seed value |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|