SMALLINT #
SMALLINT
, INT16
, I16
defines 16-bit
integer.
All integer types are signed and can be used in arithmetical operations or as part of the primary or secondary key.
The supported range is from -32768
to 32767
.
select 123;
[123]
create table example (id int16 primary key);
insert into example values (1), (2), (3);
select id from example;
[1, 2, 3]