SqlDataType Enumeration
The SqlDataType enumeration contains values that are used to specify a SQL Server data type.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.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 | No data type. | |
| 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. | |
| DateTime | A DateTime system object value that specifies a date and time between January 1, 1753 and December 31, 9999 to an accuracy of 3.33 milliseconds. | |
| 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. | |
| 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 system object value that specifies a currency value ranging from -263 (or -922,337,203,685,477.5808) to 2 63 -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. | |
| NVarChar | A variable-length byte array of Unicode characters ranging between 1 and 2^63 characters. | |
| NVarCharMax | The NVARCHAR(MAX) type. | |
| Real | A 4-bit floating point number within the range of -3.40E +38 through 3.40E +38. | |
| SmallDateTime | A DataTime system object value that specifies 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 system object 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. | |
| 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. | |
| 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). | |
| UserDefinedDataType | A user-defined data type. | |
| UserDefinedType | A SQL Server common language runtime (CLR) user-defined type. | |
| 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) 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. | |
| SysName | A system name string. | |
| Numeric | A fixed precision and fixed scale numeric value between -1038 -1 and +1038 -1. | |
| Date | Date object represents any valid Gregorian calendar date between '0001-01-01' CE and '9999-12-31' CE. | |
| Time | Time object returns values for any valid time of day based on a 24 hour clock between '00:00:00' and max '23:59:59:9999999'. | |
| DateTimeOffset | DateTimeOffset returns 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 is a time zone offset that must be between ‘-14:00’ and ‘+14:00’. | |
| DateTime2 | DateTime2 is considered an extension of the existing DATETIME object 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. | |
| UserDefinedTableType | A SQL Server common language runtime (CLR) user-defined table type. | |
| HierarchyId | HierarchyID type represents data in a hierarchy structure. For more information, see Tutorial: Using the hierarchyid Data Type | |
| Geometry | Geometry spatial type represents data in a Euclidean (flat) coordinate system. | |
| Geography | Geography spatial type represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.. |