Data Types

Data Types, 39 items

Type name	Code	Size	Sizable	Nullable	Searchable	Autoincremenal	Scale	User Type
xml	-152	0	Yes	Yes	No	No		No
sql_variant	-150	8000	No	Yes	Except like	No		No
uniqueidentifier	-11	36	Yes	Yes	Except like	No		No
ntext	-10	1073741823	Yes	Yes	Like only	No		No
nvarchar	-9	4000	Yes	Yes	Yes	No		No
sysname	-9	128	Yes	No	Yes	No		No
AccountNumber	-9	15	Yes	Yes	Yes	No		Yes
Name	-9	50	Yes	Yes	Yes	No		Yes
OrderNumber	-9	25	Yes	Yes	Yes	No		Yes
Phone	-9	25	Yes	Yes	Yes	No		Yes
nchar	-8	4000	Yes	Yes	Yes	No		No
bit	-7	1	No	Yes	Except like	No		No
Flag	-7	1	No	No	Except like	No		No
NameStyle	-7	1	No	No	Except like	No		No
tinyint	-6	3	No	Yes	Except like	No		No
tinyint identity	-6	3	No	No	Except like	Yes		No
bigint	-5	19	No	Yes	Except like	No		No
bigint identity	-5	19	No	No	Except like	Yes		No
image	-4	2147483647	Yes	Yes	No	No		No
varbinary	-3	8000	Yes	Yes	Except like	No		No
binary	-2	8000	Yes	Yes	Except like	No		No
timestamp	-2	8	Yes	No	Except like	No		No
text	-1	2147483647	Yes	Yes	Like only	No		No
char	1	8000	Yes	Yes	Yes	No		No
numeric	2	38	Yes	Yes	Except like	No	0..38	No
numeric() identity	2	38	No	No	Except like	Yes		No
decimal	3	38	Yes	Yes	Except like	No	0..38	No
money	3	19	No	Yes	Except like	No		No
smallmoney	3	10	No	Yes	Except like	No		No
decimal() identity	3	38	No	No	Except like	Yes		No
int	4	10	No	Yes	Except like	No		No
int identity	4	10	No	No	Except like	Yes		No
smallint	5	5	No	Yes	Except like	No		No
smallint identity	5	5	No	No	Except like	Yes		No
float	6	15	Yes	Yes	Except like	No		No
real	7	7	Yes	Yes	Except like	No		No
datetime	11	23	No	Yes	Yes	No		No
smalldatetime	11	16	No	Yes	Yes	No		No
varchar	12	8000	Yes	Yes	Yes	No		No