Database reference - Adventure Works DW

Table - dbo_DimSalesReason

Table properties

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

Columns

namenullscaptiondata typeordinaluniqueauto incrementauto increment seedauto increment stepdatetime modemax lengthis logicaldb column namecomputed column expression
SalesReasonKey  False  SalesReasonKey  Int32  0  True  True  0  1        SalesReasonKey   
SalesReasonAlternateKey  False  SalesReasonAlternateKey  Int32  1  False              SalesReasonAlternateKey   
SalesReasonName  False  SalesReasonName  String  2  False          50    SalesReasonName   
SalesReasonReasonType  False  SalesReasonReasonType  String  3  False          50    SalesReasonReasonType   

Referenced by

parent columnchild columnrelation namenested

Foreign key graph

dbo_DimSalesReasondbo_FactInternetSalesReason

Dependency graph

Adventure Works DWdbo_DimSalesReason

Objects that dbo_DimSalesReason depends on

nameobject typelevel
Adventure Works DWDataSourceView1



Documentation generated by SqlSpec