if database reached to max id

Ashish Mishra

suppose i am developing an web application my application has and table in database where has id coulmn as primary key and integer and it incrementing id by identity and if reach to max value then what should be done

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Accepted answer
Is this a hypothetical question for the purpose of academic discussion?
Ashish Mishra8y ago
Suppose my web application is on mvc and using mssql server express edition as data and my identity column type is of bigint and if it reached to max value .here i mean to say that bigint value is quite large but suppose if it happens then what it professionals does in .net
Nitin Sontakke8y ago
You didn't mention which database system you are using which is important while answering your question, you will agree.

Assuming you are using Microsoft SQL Server, if you are anticipating that the max limit of the Integer will be reached by your Id column you should consider using bigint from the beginning. Changing later could be a bit of a challenge.

Check below for size limits:

https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-2017