| 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 |