Database reference - Adventure Works DW

Table - FactSalesQuota

Table properties

namevalue
nameFactSalesQuota 
data source viewAdventure Works DW 
case sensitiveFalse 
display expression 
friendly nameFactSalesQuota 
db schema name 
db table nameFactSalesQuota  
typeView  

Columns

namenullscaptiondata typeordinaluniqueauto incrementauto increment seedauto increment stepdatetime modemax lengthis logicaldb column namecomputed column expression
EmployeeKey  True  EmployeeKey  Int32  0  False              EmployeeKey   
OrderDateKey  True  OrderDateKey  Int32  1  False              OrderDateKey   
CalendarYear  True  CalendarYear  String  2  False          4    CalendarYear   
CalendarQuarter  True  CalendarQuarter  Byte  3  False              CalendarQuarter   
SalesAmountQuota  True  SalesAmountQuota  Decimal  4  False              SalesAmountQuota   

References

parent columnchild columnrelation namenested
dbo_DimEmployee.  FactSalesQuota.  FK_FactSalesQuota_DimEmployee  False 
dbo_DimTime.  FactSalesQuota.  FactSalesQuota-DimTime  False 

Foreign key graph

dbo_DimEmployeedbo_DimTimeFactSalesQuota

Dependency graph

Adventure Works DWFactSalesQuota

Objects that FactSalesQuota depends on

nameobject typelevel
Adventure Works DWDataSourceView1



Documentation generated by SqlSpec