Tags: col, column, columns, database, microsoft, mysql, numeric, oracle, representation, server, sql, sys, syscolumns, system_type_id, type, view


On Database » Microsoft SQL Server

301 words with 1 Comments; publish: Wed, 02 Jan 2008 12:03:00 GMT; (25062.50, « »)

in the sys.columns view there is a col called system_type_id. It is numeric. Is this a representation of the data type of the column? If so, where does one find the mapping from the number to the data type? (i.e. 56=tinyint)

All Comments

Leave a comment...

    • Yep...look in sys.types. That is the lookup table for what you need.


      #1; Thu, 13 Sep 2007 15:03:00 GMT