Export (0) Print
Expand All

SqlDataTypeOption Enumeration

 

Applies To: SQL Server 2016 Preview

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)

[SerializableAttribute]
public enum SqlDataTypeOption

Member nameDescription
BigInt

The Type is BigInt.

Binary

The Type is Binary.

Bit

The Type is Bit.

Char

The Type is Char.

Cursor

The Type is Cursor.

Date

The Type is Date.

DateTime

The Type is DateTime.

DateTime2

The Type is DateTime2.

DateTimeOffset

The Type is DateTimeOffset.

Decimal

The Type is Decimal.

Float

The Type is Float.

Image

The Type is Image.

Int

The Type is Int.

Money

The Type is Money.

NChar

The Type is NChar.

None

The Type is None.

NText

The Type is NText.

Numeric

The Type is Numeric.

NVarChar

The Type is NVarChar.

Real

The Type is Real.

Rowversion

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.

SmallDateTime

The Type is SmallDateTime.

SmallInt

The Type is SmallInt.

SmallMoney

The Type is SmallMoney.

Sql_Variant

The Type is Sql_Variant.

Table

The Type is Table.

Text

The Type is Text.

Time

The Type is Time.

Timestamp

The Type is TimeStamp.

TinyInt

The Type is TinyInt.

UniqueIdentifier

The Type is UniqueIdentifier.

VarBinary

The Type is VarBinary.

VarChar

The Type is VarChar.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft