Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

SqlDataTypeOption Enumeration

SQL Server 2012

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

Namespace:  Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
public enum SqlDataTypeOption
Member nameDescription
BigIntThe Type is BigInt.
BinaryThe Type is Binary.
BitThe Type is Bit.
CharThe Type is Char.
CursorThe Type is Cursor.
DateThe Type is Date.
DateTimeThe Type is DateTime.
DateTime2The Type is DateTime2.
DateTimeOffsetThe Type is DateTimeOffset.
DecimalThe Type is Decimal.
FloatThe Type is Float.
ImageThe Type is Image.
IntThe Type is Int.
MoneyThe Type is Money.
NCharThe Type is NChar.
NoneThe Type is None.
NTextThe Type is NText.
NumericThe Type is Numeric.
NVarCharThe Type is NVarChar.
RealThe Type is Real.
RowversionA 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.
SmallDateTimeThe Type is SmallDateTime.
SmallIntThe Type is SmallInt.
SmallMoneyThe Type is SmallMoney.
Sql_VariantThe Type is Sql_Variant.
TableThe Type is Table.
TextThe Type is Text.
TimeThe Type is Time.
TimestampThe Type is TimeStamp.
TinyIntThe Type is TinyInt.
UniqueIdentifierThe Type is UniqueIdentifier.
VarBinaryThe Type is VarBinary.
VarCharThe Type is VarChar.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.