Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)
Syntax
'Declaration
<SerializableAttribute> _
Public Enumeration SqlDataTypeOption
'Usage
Dim instance As SqlDataTypeOption
[SerializableAttribute]
public enum SqlDataTypeOption
[SerializableAttribute]
public enum class SqlDataTypeOption
[<SerializableAttribute>]
type SqlDataTypeOption
public enum SqlDataTypeOption
Members
Member name | Description | |
---|---|---|
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. |