Table: DimProductCategory

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimProductCategory 
 Friendly name   Product Category 
 Table name   dbo_DimProductCategory 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


No relationships exist

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_DimProductSubcategory_DimProductCategory ProductCategoryKey DimProductSubcategory Table ProductCategoryKey
Total: 1 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
ProductCategoryKey System.Int32  
ProductCategoryAlternateKey System.Int32  
EnglishProductCategoryName System.String  
SpanishProductCategoryName System.String  
FrenchProductCategoryName System.String  
Total: 5 column(s)

Collapse image See also


About this documentation