Find integer columns nearing the max column value


Is there any way to find all columns in all tables in a database where the max value is approaching the max value of the integer column ?

eg - when column is integer

Select * from table where max(column) > 2147480000

Hi, you should be able to write a script to determine this by querying the max(col) for each column for each table and comparing to the max possible value. Something like this for example:

Please note I haven’t tested it so use with care