Question: what is the difference between int and smallint?
Answer: Both data types are stored as signed binary integers. INTEGER values have 32 bits and can represent whole numbers from –2 31–1 through 2 31–1. SMALLINT values have only 16 bits. They can represent whole numbers from –32,767 through 32,767.