SqlDataTypeOption Enum

Definition

Namespace:

Microsoft.SqlServer.TransactSql.ScriptDom

Assembly:

Microsoft.SqlServer.TransactSql.ScriptDom.dll

Package:

Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

These are the possible data types in Sql. The capitalization of names are influenced by System.Data.SqlDbType.

[System.Serializable]
public enum SqlDataTypeOption

[<System.Serializable>]
type SqlDataTypeOption = 

Public Enum SqlDataTypeOption

Inheritance

Enum

SqlDataTypeOption

Attributes

SerializableAttribute

Fields

Name	Value	Description
None	0	Nothing was defined.
BigInt	1	Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).
Int	2	Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).
SmallInt	3	Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767).
TinyInt	4	Integer data from 0 through 255.
Bit	5	Integer data with either a 1 or 0 value.
Decimal	6	Fixed precision and scale numeric data from -10^38 +1 through 10^38 �1.
Numeric	7	Functionally equivalent to decimal.
Money	8	Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.
SmallMoney	9	Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit.
Float	10	Floating precision number data with the following valid values: -1.79E + 308 through -2.23E - 308, 0 and 2.23E + 308 through 1.79E + 308.
Real	11	Floating precision number data with the following valid values: -3.40E + 38 through -1.18E - 38, 0 and 1.18E - 38 through 3.40E + 38.
DateTime	12	Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.
SmallDateTime	13	Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute.
Char	14	Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
VarChar	15	Variable-length non-Unicode data with a maximum of 8,000 characters.
Text	16	Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters.
NChar	17	Fixed-length Unicode data with a maximum length of 4,000 characters.
NVarChar	18	Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names.
NText	19	Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters.
Binary	20	Fixed-length binary data with a maximum length of 8,000 bytes.
VarBinary	21	Variable-length binary data with a maximum length of 8,000 bytes.
Image	22	Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes.
Cursor	23	A reference to a cursor.
Sql_Variant	24	A data type that stores values of various SQL Server-supported data types, except text, ntext, timestamp, and sql_variant.
Table	25	A special data type used to store a result set for later processing.
Timestamp	26	A database-wide unique number that gets updated every time a row gets updated.
UniqueIdentifier	27	Is a 16-byte GUID
Date	29	Date-only
Time	30	Time only
DateTime2	31	Combination of data and time types, better precision than DataTime
DateTimeOffset	32	Same as DateTime2 with timezone offset added
Rowversion	33	A database-wide unique number that gets updated every time a row gets updated. A synonym for Timestamp with different semantics requiring a named column of this type.