Database reference - Adventure Works DW

Table - dbo_DimProductCategory

Table properties

namevalue
namedbo_DimProductCategory 
data source viewAdventure Works DW 
case sensitiveFalse 
display expression 
friendly nameDimProductCategory 
db schema namedbo 
db table nameDimProductCategory  
typeTable  

Columns

namenullscaptiondata typeordinaluniqueauto incrementauto increment seedauto increment stepdatetime modemax lengthis logicaldb column namecomputed 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   

Referenced by

parent columnchild columnrelation namenested

Foreign key graph

dbo_DimProductCategorydbo_DimProductSubcategory

Dependency graph

Adventure Works DWdbo_DimProductCategory

Objects that dbo_DimProductCategory depends on

nameobject typelevel
Adventure Works DWDataSourceView1



Documentation generated by SqlSpec