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
'Deklaracja
Public Enumeration SqlDataType
public enum SqlDataType
public enum class SqlDataType
public enum SqlDataType
public enum SqlDataType
Members
| Member name | Description |
|---|---|
| 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 | Date object represents any valid Gregorian calendar date between '0001-01-01' CE and '9999-12-31' CE. |
| 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. |
| 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. |
| 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’. |
| 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 | 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.. |
| Geometry | Geography spatial type represents data in a Euclidean (flat) coordinate system. |
| HierarchyId | |
| 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. |
| None | No data type. |
| 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) 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. |
| 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 | 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'. |
| 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. |
| UserDefinedTableType | A SQL Server common language runtime (CLR) user-defined table 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. |
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.