[thelist] INT VS BIGINT

[Russell Griechen]

rudy...the resident SQL poet laureaute wrote:

>don't use BIGINT unless you plan to have more than 2,147,483,647 categories

>don't use INTEGER unless you plan to have more than 32,767

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
b. simply change the INT TO BIGINT
????
c. Can you just flush the data and droptables?
Russell Griechen