Link to home
Start Free TrialLog in
Avatar of hrvica5
hrvica5Flag for Croatia

asked on

mssql

Hi,

i have autoincrement ID in sql


and my ID's in table goes like this

1
2
3
6
8

because i deleted some rows.

how to set id
1
2
3
4
5


thx
Avatar of Lee
Lee
Flag of United Kingdom of Great Britain and Northern Ireland image

I wouldn't do this if this ID is used as a foreign key in other tables as it will break your database.
Avatar of hrvica5

ASKER

no it isn't
ASKER CERTIFIED SOLUTION
Avatar of Lee
Lee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Only do this if you really require it.