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. |