SqlDataType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
SQL Server built-in data types
public enum SqlDataType
type SqlDataType =
Public Enum SqlDataType
- Inheritance
-
SqlDataType
Fields
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). |
Binary | 20 | Fixed-length binary data with a maximum length of 8,000 bytes. |
Bit | 5 | Integer data with either a 1 or 0 value. |
Char | 14 | Fixed-length non-Unicode character data with a maximum length of 8,000 characters. |
Cursor | 23 | A reference to a cursor. |
Date | 29 | Date-only |
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. |
DateTime2 | 31 | Combination of data and time types, better precision than DataTime |
DateTimeOffset | 32 | Same as DateTime2 with timezone offset added |
Decimal | 6 | Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1. |
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. |
Image | 22 | Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes. |
Int | 2 | Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). |
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. |
NChar | 17 | Fixed-length Unicode data with a maximum length of 4,000 characters. |
NText | 19 | Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. |
Numeric | 7 | Functionally equivalent to decimal. |
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. |
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. |
Rowversion | 33 | (Alias for Timestamp) A database-wide unique number that gets updated every time a row gets updated. |
SmallDateTime | 13 | Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute. |
SmallInt | 3 | Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). |
SmallMoney | 9 | Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. |
Table | 25 | A special data type used to store a result set for later processing. |
Text | 16 | Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. |
Time | 30 | Time only |
Timestamp | 26 | A database-wide unique number that gets updated every time a row gets updated. |
TinyInt | 4 | Integer data from 0 through 255. |
UniqueIdentifier | 27 | Is a 16-byte GUID |
Unknown | 0 | Nothing was defined. |
VarBinary | 21 | Variable-length binary data with a maximum length of 8,000 bytes. |
VarChar | 15 | Variable-length non-Unicode data with a maximum of 8,000 characters. |
Variant | 24 | A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant. |
Xml | 28 | xml data type |