| name | value |
|---|---|
| name | dbo_DimProductCategory |
| data source view | Adventure Works DW |
| case sensitive | False |
| display expression | |
| friendly name | DimProductCategory |
| db schema name | dbo |
| db table name | DimProductCategory |
| type | Table |
| name | nulls | caption | data type | ordinal | unique | auto increment | auto increment seed | auto increment step | datetime mode | max length | is logical | db column name | computed column expression |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ProductCategoryKey | False | ProductCategoryKey | Int32 | 0 | True | True | 0 | 1 | ProductCategoryKey | ||||
| ProductCategoryAlternateKey | True | ProductCategoryAlternateKey | Int32 | 1 | False | ProductCategoryAlternateKey | |||||||
| EnglishProductCategoryName | True | EnglishProductCategoryName | String | 2 | False | 50 | EnglishProductCategoryName | ||||||
| SpanishProductCategoryName | True | SpanishProductCategoryName | String | 3 | False | 50 | SpanishProductCategoryName | ||||||
| FrenchProductCategoryName | True | FrenchProductCategoryName | String | 4 | False | 50 | FrenchProductCategoryName |
| parent column | child column | relation name | nested |
|---|
| name | object type | level |
|---|---|---|
| Adventure Works DW | DataSourceView | 1 |