Data Type Analysis (Primary Keys)
|
Fact
|
SQLServerType
|
is_identity
|
key_ordinal
|
Objects
|
Columns
|
31
|
date
|
False
|
2
|
1
|
1
|
31
|
datetime
|
False
|
2
|
5
|
5
|
31
|
hierarchyid
|
False
|
1
|
1
|
1
|
31
|
hierarchyid
|
False
|
2
|
1
|
1
|
31
|
int
|
False
|
1
|
29
|
29
|
31
|
int
|
False
|
2
|
10
|
10
|
31
|
int
|
False
|
3
|
4
|
4
|
31
|
int
|
True
|
1
|
31
|
31
|
31
|
int
|
True
|
2
|
3
|
3
|
31
|
nchar(0003)
|
False
|
1
|
2
|
2
|
31
|
nchar(0003)
|
False
|
2
|
1
|
1
|
31
|
nchar(0006)
|
False
|
1
|
1
|
1
|
31
|
nchar(0006)
|
False
|
3
|
1
|
1
|
31
|
nvarchar(0003)
|
False
|
1
|
2
|
2
|
31
|
Phone
|
False
|
2
|
1
|
1
|
31
|
smallint
|
False
|
2
|
1
|
1
|
31
|
smallint
|
False
|
3
|
2
|
2
|
31
|
smallint
|
True
|
1
|
3
|
3
|
31
|
tinyint
|
False
|
4
|
1
|
1
|
31
|
tinyint
|
True
|
1
|
2
|
2
|