Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SQL Server built-in data types
Namespace: Microsoft.SqlServer.Dac.Model
Assembly: Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)
Syntax
'Declaration
Public Enumeration SqlDataType
'Usage
Dim instance As SqlDataType
public enum SqlDataType
public enum class SqlDataType
type SqlDataType
public enum SqlDataType
Members
| Member name | Description | |
|---|---|---|
| BigInt | 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 | Fixed-length binary data with a maximum length of 8,000 bytes. | |
| Bit | Integer data with either a 1 or 0 value. | |
| Char | Fixed-length non-Unicode character data with a maximum length of 8,000 characters. | |
| Cursor | A reference to a cursor. | |
| Date | Date-only | |
| DateTime | 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 | Combination of data and time types, better precision than DataTime | |
| DateTimeOffset | Same as DateTime2 with timezone offset added | |
| Decimal | Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1. | |
| Float | 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 | Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes. | |
| Int | Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). | |
| Money | 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 | Fixed-length Unicode data with a maximum length of 4,000 characters. | |
| NText | Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. | |
| Numeric | Functionally equivalent to decimal. | |
| NVarChar | 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 | 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 | (Alias for Timestamp) A database-wide unique number that gets updated every time a row gets updated. | |
| SmallDateTime | Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute. | |
| SmallInt | Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). | |
| SmallMoney | Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. | |
| Table | A special data type used to store a result set for later processing. | |
| Text | Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. | |
| Time | Time only | |
| Timestamp | A database-wide unique number that gets updated every time a row gets updated. | |
| TinyInt | Integer data from 0 through 255. | |
| UniqueIdentifier | Is a 16-byte GUID | |
| Unknown | Nothing was defined. | |
| VarBinary | Variable-length binary data with a maximum length of 8,000 bytes. | |
| VarChar | Variable-length non-Unicode data with a maximum of 8,000 characters. | |
| Variant | A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant. | |
| Xml | xml data type |