SqlDataType Enum

Definition

Namespace:

Microsoft.SqlServer.Dac.Model

Assembly:

Microsoft.SqlServer.Dac.Extensions.dll

Package:

Microsoft.SqlServer.DacFx v162.2.111

SQL Server built-in data types

public enum SqlDataType

type SqlDataType = 

Public Enum SqlDataType

Inheritance

Enum

SqlDataType

Fields

Name	Value	Description
Unknown	0	Nothing was defined.
BigInt	1	Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).
Int	2	Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).
SmallInt	3	Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767).
TinyInt	4	Integer data from 0 through 255.
Bit	5	Integer data with either a 1 or 0 value.
Decimal	6	Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1.
Numeric	7	Functionally equivalent to decimal.
Money	8	Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
SmallMoney	9	Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.
Float	10	Floating precision number data with the following valid values: -1.79E + 308 through -2.23E - 308, 0 and 2.23E + 308 through 1.79E + 308.
Real	11	Floating precision number data with the following valid values: -3.40E + 38 through -1.18E - 38, 0 and 1.18E - 38 through 3.40E + 38.
DateTime	12	Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.
SmallDateTime	13	Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute.
Char	14	Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
VarChar	15	Variable-length non-Unicode data with a maximum of 8,000 characters.
Text	16	Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters.
NChar	17	Fixed-length Unicode data with a maximum length of 4,000 characters.
NVarChar	18	Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names.
NText	19	Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters.
Binary	20	Fixed-length binary data with a maximum length of 8,000 bytes.
VarBinary	21	Variable-length binary data with a maximum length of 8,000 bytes.
Image	22	Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes.
Cursor	23	A reference to a cursor.
Variant	24	A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant.
Table	25	A special data type used to store a result set for later processing.
Timestamp	26	A database-wide unique number that gets updated every time a row gets updated.
UniqueIdentifier	27	Is a 16-byte GUID
Xml	28	xml data type
Date	29	Date-only
Time	30	Time only
DateTime2	31	Combination of data and time types, better precision than DataTime
DateTimeOffset	32	Same as DateTime2 with timezone offset added
Rowversion	33	(Alias for Timestamp) A database-wide unique number that gets updated every time a row gets updated.