SMALLINT type

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Represents 2-byte signed integer numbers.

Syntax 

{ SMALLINT | SHORT }

Limits

The range of numbers is from -32,768 to 32,767.

Literals 

[ + | - ] digit [ ... ] S

digit: Any numeral from 0 to 9.

The postfix S is case insensitive.

Examples 

> SELECT +1S;
  1

> SELECT CAST('5' AS SMALLINT);
  5