Data Types

Data Types, 39 items

Type nameCodeSizeSizableNullableSearchableAutoincremenalScaleUser Type
xml-1520YesYesNoNo No
sql_variant-1508000NoYesExcept likeNo No
uniqueidentifier-1136YesYesExcept likeNo No
ntext-101073741823YesYesLike onlyNo No
nvarchar-94000YesYesYesNo No
sysname-9128YesNoYesNo No
AccountNumber-915YesYesYesNo Yes
Name-950YesYesYesNo Yes
OrderNumber-925YesYesYesNo Yes
Phone-925YesYesYesNo Yes
nchar-84000YesYesYesNo No
bit-71NoYesExcept likeNo No
Flag-71NoNoExcept likeNo No
NameStyle-71NoNoExcept likeNo No
tinyint-63NoYesExcept likeNo No
tinyint identity-63NoNoExcept likeYes No
bigint-519NoYesExcept likeNo No
bigint identity-519NoNoExcept likeYes No
image-42147483647YesYesNoNo No
varbinary-38000YesYesExcept likeNo No
binary-28000YesYesExcept likeNo No
timestamp-28YesNoExcept likeNo No
text-12147483647YesYesLike onlyNo No
char18000YesYesYesNo No
numeric238YesYesExcept likeNo0..38No
numeric() identity238NoNoExcept likeYes No
decimal338YesYesExcept likeNo0..38No
money319NoYesExcept likeNo No
smallmoney310NoYesExcept likeNo No
decimal() identity338NoNoExcept likeYes No
int410NoYesExcept likeNo No
int identity410NoNoExcept likeYes No
smallint55NoYesExcept likeNo No
smallint identity55NoNoExcept likeYes No
float615YesYesExcept likeNo No
real77YesYesExcept likeNo No
datetime1123NoYesYesNo No
smalldatetime1116NoYesYesNo No
varchar128000YesYesYesNo No