SqlDataType Enumeration

Specifies the SQL Server built-in data type.

Namespace:  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.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
	None	The data type is unknown.
	BigInt	A 64-bit signed integer.
	Binary	A fixed-length byte array ranging between 1 and 8,000 bytes.
	Bit	An unsigned bit value that can be 0, 1, or a null reference.
	Char	A fixed-length byte array of non-Unicode (256 code page) characters ranging between 1 and 8,000 characters.
	Date	Represents any valid Gregorian calendar date between '0001-01-01' CE and '9999-12-31' CE.
	DateTime	A date and time between January 1, 1753 and December 31, 9999 to an accuracy of 3.33 milliseconds.
	DateTime2	An extension of the existing datetime data type with a large date range and large default fractional precision. Values that represent any valid Gregorian calendar date between ‘0001-01-01’ CE and ‘9999-12-31’ CE combined with any valid time of day based on a 24-hour clock.
	DateTimeOffset	A valid Gregorian calendar date between `0001-01-01’ and ‘9999-12-31’ with any valid time of day based on a 24-hour format between ’00:00:00’ and max ’23:59:49.9999999’. Included in the datetimeoffset value is a time zone offset that must be between ‘-14:00’ and ‘+14:00’.
	Decimal	A fixed precision and fixed scale numeric value between -1038 -1 and +1038 -1.
	Float	An 8-byte floating point number within the range of -1.79E +308 through 1.79E +308.
	Geography	Represents data in a round-earth coordinate system. The geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.
	Geometry	Represents data in a Euclidean (flat) coordinate system.
	HierarchyId	A position in a hierarchy.
	Image	A variable-length byte array ranging from 0 to 231 -1 (or 2,147,483,647) bytes.
	Int	A 32-bit signed integer.
	Money	A decimal value that specifies a currency value ranging from -263 (or -922,337,203,685,477.5808) to 263 -1 (or +922,337,203,685,477.5807)with an accuracy of 1 in 10,000 of a currency unit.
	NChar	A fixed-length byte array of Unicode characters ranging between 1 and 4,000 characters.
	NText	A variable-length byte array of Unicode data with a maximum length of 230 - 1 (or 1,073,741,823) characters.
	Numeric	A fixed precision and fixed scale numeric value between -1038 -1 and +1038 -1.
	NVarChar	A variable-length byte array of Unicode characters ranging between 1 and 2^63 characters.
	NVarCharMax	The nvarchar(max) data type.
	Real	A 4-bit floating point number within the range of -3.40E +38 through 3.40E +38.
	SmallDateTime	A date and time between January 1, 1900 and June 6, 2079 to an accuracy of one minute.
	SmallInt	A 16-bit signed integer.
	SmallMoney	A decimal value that specifies a currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy of 1 in 10,000 of a currency unit.
	SysName	A system name string.
	Text	A variable-length byte array of non-Unicode (256 code page) data with a maximum length of 231 -1 (or 2,147,483,647) characters.
	Time	A time of day based on a 24-hour clock between '00:00:00' and max '23:59:59:9999999'.
	Timestamp	An automatically generated byte array value, which is guaranteed to be unique within a database.
	TinyInt	An 8-bit unsigned integer.
	UniqueIdentifier	A globally unique identifier (or GUID).
	VarBinary	A variable-length byte array ranging between 1 and 2^64 bytes.
	VarBinaryMax	A varbinary(max) type.
	VarChar	A variable-length byte array of non-Unicode (256 cod epage) characters ranging between 1 and 2^64 characters.
	VarCharMax	A varchar(max) data type.
	Variant	A special data type that can contain numeric, string, binary, date data, and the SQL Server values Empty and Null. This data type is assumed if no other type is declared.
	Xml	An xml data type.

See Also

Reference

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace