[thelist] INT VS BIGINT

[rudy]

> If I start with INTEGER and later on get close to the 2,147* entries what
> are my options.
> a. drop table *** ....convert to BIGINT

if you have over 2 billion rows, then dropping the table may take a while

reloading it certainly will

> b. simply change the INT TO BIGINT

some databases may let you do that in an ALTER, yes

try it with a few rows now, before it gets near 2 billion...


rudy