Index full

I use int for primary key and set auto increase.

May I know when it increase and reach the max limit, what will it do?

Stop there or start from 0 again.

Thanks.
turbot_yuAsked:
Who is Participating?
 
Kentrix70Connect With a Mentor Commented:
To know the limit of int, you can check this out:

http://forums.asp.net/p/986099/1271198.aspx#1271198

..and about what happens if you reach the limit

http://stackoverflow.com/questions/261815/upper-limit-for-autoincrement-primary-key-in-sql-server

As it is stated on the web page for the last link you can use bigint instead,
which has a REALLY HIGH LIMIT :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.