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