Database reference - Adventure Works DW

Table - dbo_DimAccount

Table properties

name	value
name	dbo_DimAccount
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimAccount
db schema name	dbo
db table name	DimAccount
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
AccountKey	False	AccountKey	Int32	0	True	True	0	1				AccountKey
ParentAccountKey	True	ParentAccountKey	Int32	1	False							ParentAccountKey
AccountCodeAlternateKey	True	AccountCodeAlternateKey	Int32	2	False							AccountCodeAlternateKey
ParentAccountCodeAlternateKey	True	ParentAccountCodeAlternateKey	Int32	3	False							ParentAccountCodeAlternateKey
AccountDescription	True	AccountDescription	String	4	False					50		AccountDescription
AccountType	True	AccountType	String	5	False					50		AccountType
Operator	True	Operator	String	6	False					50		Operator
CustomMembers	True	CustomMembers	String	7	False					300		CustomMembers
ValueType	True	ValueType	String	8	False					50		ValueType
CustomMemberOptions	True	CustomMemberOptions	String	9	False					200		CustomMemberOptions

References

parent column	child column	relation name	nested
dbo_DimAccount.	dbo_DimAccount.	FK_DimAccount_DimAccount	False

Referenced by

parent column	child column	relation name	nested
dbo_DimAccount.	dbo_DimAccount.	FK_DimAccount_DimAccount	False

Foreign key graph

dbo_DimAccountdbo_DimAccount dbo_DimAccountdbo_FactFinance

Dependency graph

Adventure Works DWdbo_DimAccount

Objects that dbo_DimAccount depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Documentation generated by SqlSpec