SQL SMALLINT Data Type

A table with a SMALLINT column.

CREATE TABLE DemoTable  
( 
  Id INT IDENTITY, 
  BuildingName VARCHAR(100),
  Age SMALLINT
);
GO  

INSERT INTO DemoTable VALUES ('Ancestral Puebloan dwellings', 173);  
INSERT INTO DemoTable VALUES ('Deane Winthrop House', 346);  
INSERT INTO DemoTable VALUES ('White Horse Tavern', 369);
INSERT INTO DemoTable VALUES ('Old Powder House', 274); 
INSERT INTO DemoTable VALUES ('Chaco Canyon', NULL); 
GO  

SELECT * FROM DemoTable;
GO

DROP TABLE DemoTable;
GO

CREATE TABLE DemoTable  
( 
  MyBigInt BIGINT,
  MyInt INT,
  MySmallInt SMALLINT,
  MyTinyInt TINYINT
);
GO  

INSERT INTO DemoTable VALUES (9223372036854775807, 2147483647, 32767, 255);  
GO  

SELECT * FROM DemoTable;
GO

DROP TABLE DemoTable;
GO

• Our Sql TINYINT Data Type Reference
• Our Sql INT Data Type Reference
• Our Sql BIGINT Data Type Reference