Database reference - Adventure Works DW

Table - dbo_DimOrganization

Table properties

name	value
name	dbo_DimOrganization
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimOrganization
db schema name
db table name	DimOrganization
type	View

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
OrganizationKey	False	OrganizationKey	Int32	0	True	True	0	1				OrganizationKey
ParentOrganizationKey	True	ParentOrganizationKey	Int32	1	False							ParentOrganizationKey
PercentageOfOwnership	True	PercentageOfOwnership	String	2	False					16		PercentageOfOwnership
OrganizationName	True	OrganizationName	String	3	False					50		OrganizationName
CurrencyAlternateKey	True	CurrencyAlternateKey	String	4	False					3		CurrencyAlternateKey
CurrencyKey	True	CurrencyKey	Int32	5	False							CurrencyKey

References

parent column	child column	relation name	nested
dbo_DimOrganization.	dbo_DimOrganization.	FK_DimOrganization_DimOrganization	False
DimDestinationCurrency.	dbo_DimOrganization.	DimOrganization-DimDestinationCurrency	False

Referenced by

parent column	child column	relation name	nested
dbo_DimOrganization.	dbo_DimOrganization.	FK_DimOrganization_DimOrganization	False
DimDestinationCurrency.	dbo_DimOrganization.	DimOrganization-DimDestinationCurrency	False

Foreign key graph

dbo_DimOrganizationDimDestinationCurrencydbo_DimOrganization dbo_DimOrganizationdbo_FactFinance

Dependency graph

Adventure Works DWdbo_DimOrganization

Objects that dbo_DimOrganization depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Documentation generated by SqlSpec