Share via


SqlDataType Enumeration

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

See Also

Reference

Microsoft.SqlServer.Dac.Model Namespace