Export (0) Print
Expand All
Expand Minimize

SqlDataType Enumeration

The SqlDataType enumeration contains values that are used to specify a Microsoft SQL Server data type.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

public enum SqlDataType
public enum SqlDataType
public enum SqlDataType

Member nameDescription
BigIntA 64-bit signed integer.
BinaryA fixed-length byte array ranging between 1 and 8,000 bytes.
BitAn unsigned bit value that can be 0, 1, or a null reference.
CharA fixed-length byte array of non-Unicode (256 code page) characters ranging between 1 and 8,000 characters.
DateTimeA 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.
DecimalA fixed precision and fixed scale numeric value between -1038 -1 and +1038 -1.
FloatAn 8-byte floating point number within the range of -1.79E +308 through 1.79E +308.
ImageA variable-length byte array ranging from 0 to 231 -1 (or 2,147,483,647) bytes.
IntA 32-bit signed integer.
MoneyA 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.
NCharA fixed-length byte array of Unicode characters ranging between 1 and 4,000 characters.
NoneNo data type.
NTextA variable-length byte array of Unicode data with a maximum length of 230 - 1 (or 1,073,741,823) characters.
NumericA fixed precision and fixed scale numeric value between -1038 -1 and +1038 -1.
NVarCharA variable-length byte array of Unicode characters ranging between 1 and 2^63 characters.
NVarCharMaxThe NVARCHAR(MAX) type.
RealA 4-bit floating point number within the range of -3.40E +38 through 3.40E +38.
SmallDateTimeA DataTime system object value that specifies a date and time between January 1, 1900 and June 6, 2079 to an accuracy of one minute.
SmallIntA 16-bit signed integer.
SmallMoneyA 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.
SysNameA system name string.
TextA variable-length byte array of non-Unicode (256 code page) data with a maximum length of 231 -1 (or 2,147,483,647) characters.
TimestampAn automatically generated byte array value, which is guaranteed to be unique within a database.
TinyIntAn 8-bit unsigned integer.
UniqueIdentifierA globally unique identifier (or GUID).
UserDefinedDataTypeA user-defined data type.
UserDefinedTypeA SQLServer common language runtime (CLR) user-defined type.
VarBinaryA variable-length byte array ranging between 1 and 2^64 bytes.
VarBinaryMaxA VARBINARY(MAX) type.
VarCharA variable-length byte array of non-Unicode (256 cod epage) characters ranging between 1 and 2^64 characters.
VarCharMaxA VARCHAR(MAX) type.
VariantA special data type that can contain numeric, string, binary, date data, and the Microsoft SQL Server values Empty and Null. This data type is assumed if no other type is declared.
XmlAn XML data type.

The SqlDataType enumeration class is served by the SqlDataType property.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft