On Transact SQL language the tinyint is an numeric data type. The maximum value of tinyint data type is 255.
Tinyint syntax:
| Range | Storage |
|---|---|
| 0 to 255 | 1 Byte |
Tinyint example:
USE model;
GO
CREATE TABLE myTinyintTable ( d tinyint );
GO
INSERT INTO myTinyintTable VALUES (255);
GO
SELECT d FROM myTinyintTable;
GO
| Results |
|---|
| 255 |