This data type defines a field that holds whole numbers between -32,768 and 32,767. Smallint fields require 2 bytes of storage. Fractional values inserted into a small integer field are truncated. If the field is specified as NOT NULL WITH DEFAULT, null values will be replaced by zero.