Database reference - Adventure Works DW

Table - dbo_FactInternetSalesReason

Table properties

name	value
name	dbo_FactInternetSalesReason
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	FactInternetSalesReason
db schema name	dbo
db table name	FactInternetSalesReason
type	Table

Columns

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
SalesOrderNumber	False	SalesOrderNumber	String	0	False					20		SalesOrderNumber
SalesOrderLineNumber	False	SalesOrderLineNumber	Byte	1	False							SalesOrderLineNumber
SalesReasonKey	False	SalesReasonKey	Int32	2	False							SalesReasonKey

References

parent column	child column	relation name	nested
dbo_DimSalesReason.	dbo_FactInternetSalesReason.	FK_FactInternetSalesReason_DimSalesReason	False
dbo_FactInternetSales.	dbo_FactInternetSalesReason.	FK_FactInternetSalesReason_FactInternetSales	False

Foreign key graph

dbo_DimSalesReasondbo_FactInternetSalesdbo_FactInternetSalesReason

Dependency graph

Adventure Works DWdbo_FactInternetSalesReason

Objects that dbo_FactInternetSalesReason depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Documentation generated by SqlSpec