SQL Server (Transact-SQL) Data Types to system_type_id list

I received metadata for a SQL Server 2008 R2 database which contained the system_type_id but not the data type itself. I ran a bunch of queries and logged the results to obtain a list of system_type_ids and the corresponding datatypes.

I looked on MSDN and was unable to find a list so I compiled one for usage for you google-ninjas who may find it handy.

system_type_id datatype
34 image
35 text
36 uniqueidentifier
40 date
41 time
42 datetime2
48 tinyint
52 smallint
56 int
58 smalldatetime
59 real
60 money
61 datetime
62 float
98 sql_variant
99 ntext
104 bit
106 decimal
108 numeric
122 smallmoney
127 bigint
165 varbinary
167 varchar
173 binary
175 char
189 timestamp
231 nvarchar
239 nchar
241 xml

Leave a Reply

Your email address will not be published. Required fields are marked *