Export (0) Print
Expand All
Expand Minimize

SqlDataTypeOption Enumeration

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft