SQLSERVER里的各种数据类型以及对应的system_type_id

转自：https://www.cnblogs.com/lyhabc/articles/4037322.html

namespace OrcaMDF.Core.MetaData.Enumerations
{
    public enum SystemType : byte
    {
        Image                = 34,
        Text                = 35,
        Uniqueidentifier    = 36,
        Date                = 40,
        Time                = 41,
        Datetime2            = 42,
        DatetimeOffset        = 43,
        Tinyint                = 48,
        Smallint            = 52,
        Int                    = 56,
        Smalldatetime        = 58,
        Real                = 59,
        Money                = 60,
        Datetime            = 61,
        Float                = 62,
        Sql_Variant            = 98,
        Ntext                = 99,
        Bit                    = 104,
        Decimal                = 106,
        Numeric                = 108,
        Smallmoney            = 122,
        Bigint                = 127,
        Hierarchyid            = 240,
        Geometry            = 240,
        Geography            = 240,
        Varbinary            = 165,
        Varchar                = 167,
        Binary                = 173,
        Char                = 175,
        Timestamp            = 189,
        Nvarchar            = 231,
        Nchar                = 239,
        Xml                    = 241,
        Sysname                = 231
    }
}