Data Type Analysis (Table Columns)
|
Fact
|
SQLServerType
|
is_nullable
|
is_computed
|
Objects
|
Columns
|
32
|
AccountNumber
|
False
|
False
|
1
|
1
|
32
|
AccountNumber
|
True
|
False
|
1
|
1
|
32
|
bit
|
False
|
False
|
1
|
1
|
32
|
date
|
False
|
False
|
2
|
3
|
32
|
date
|
True
|
False
|
1
|
1
|
32
|
datetime
|
False
|
False
|
71
|
94
|
32
|
datetime
|
True
|
False
|
10
|
12
|
32
|
decimal(08,02)
|
False
|
False
|
3
|
4
|
32
|
decimal(08,02)
|
True
|
False
|
1
|
1
|
32
|
decimal(09,02)
|
False
|
True
|
1
|
1
|
32
|
decimal(09,04)
|
True
|
False
|
1
|
1
|
32
|
Flag
|
False
|
False
|
6
|
9
|
32
|
geography
|
True
|
False
|
1
|
1
|
32
|
hierarchyid
|
False
|
False
|
2
|
2
|
32
|
hierarchyid
|
True
|
False
|
1
|
1
|
32
|
int
|
False
|
False
|
61
|
115
|
32
|
int
|
False
|
True
|
1
|
1
|
32
|
int
|
True
|
False
|
10
|
18
|
32
|
money
|
False
|
False
|
17
|
30
|
32
|
money
|
False
|
True
|
3
|
3
|
32
|
money
|
True
|
False
|
3
|
3
|
32
|
Name
|
False
|
False
|
24
|
27
|
32
|
Name
|
True
|
False
|
1
|
1
|
32
|
NameStyle
|
False
|
False
|
1
|
1
|
32
|
nchar(0001)
|
False
|
False
|
3
|
4
|
32
|
nchar(0002)
|
False
|
False
|
1
|
1
|
32
|
nchar(0002)
|
True
|
False
|
1
|
3
|
32
|
nchar(0003)
|
False
|
False
|
7
|
8
|
32
|
nchar(0003)
|
True
|
False
|
1
|
2
|
32
|
nchar(0005)
|
False
|
False
|
1
|
1
|
32
|
nchar(0006)
|
False
|
False
|
2
|
2
|
32
|
numeric(38,06)
|
False
|
True
|
1
|
1
|
32
|
nvarchar(0003)
|
False
|
False
|
4
|
4
|
32
|
nvarchar(0005)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0008)
|
False
|
False
|
1
|
1
|
32
|
nvarchar(0008)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0010)
|
False
|
False
|
1
|
1
|
32
|
nvarchar(0010)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0015)
|
False
|
False
|
2
|
2
|
32
|
nvarchar(0015)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0025)
|
False
|
False
|
3
|
3
|
32
|
nvarchar(0025)
|
False
|
True
|
1
|
1
|
32
|
nvarchar(0025)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0030)
|
False
|
False
|
1
|
1
|
32
|
nvarchar(0050)
|
False
|
False
|
7
|
8
|
32
|
nvarchar(0050)
|
True
|
False
|
2
|
3
|
32
|
nvarchar(0060)
|
False
|
False
|
1
|
1
|
32
|
nvarchar(0060)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0126)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0128)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(0255)
|
False
|
False
|
1
|
1
|
32
|
nvarchar(0256)
|
False
|
False
|
1
|
1
|
32
|
nvarchar(0400)
|
False
|
False
|
2
|
2
|
32
|
nvarchar(1024)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(3850)
|
True
|
False
|
1
|
1
|
32
|
nvarchar(4000)
|
False
|
False
|
1
|
1
|
32
|
nvarchar(max )
|
False
|
False
|
1
|
1
|
32
|
nvarchar(max )
|
True
|
False
|
1
|
1
|
32
|
OrderNumber
|
True
|
False
|
1
|
1
|
32
|
Phone
|
False
|
False
|
1
|
1
|
32
|
smallint
|
False
|
False
|
13
|
17
|
32
|
smallint
|
True
|
False
|
1
|
1
|
32
|
smallint
|
True
|
True
|
2
|
2
|
32
|
smallmoney
|
False
|
False
|
4
|
4
|
32
|
sysname
|
False
|
False
|
2
|
3
|
32
|
sysname
|
True
|
False
|
1
|
2
|
32
|
time(7)
|
False
|
False
|
1
|
2
|
32
|
tinyint
|
False
|
False
|
11
|
13
|
32
|
uniqueidentifier
|
False
|
False
|
29
|
29
|
32
|
varbinary(max )
|
True
|
False
|
2
|
3
|
32
|
varchar(0010)
|
False
|
False
|
1
|
1
|
32
|
varchar(0010)
|
False
|
True
|
1
|
1
|
32
|
varchar(0015)
|
True
|
False
|
1
|
1
|
32
|
varchar(0128)
|
False
|
False
|
1
|
1
|
32
|
xml
|
False
|
False
|
1
|
1
|
32
|
xml
|
True
|
False
|
5
|
7
|