Database reference - Adventure Works DW

Table - dbo_DimDepartmentGroup

Table properties

name	value
name	dbo_DimDepartmentGroup
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimDepartmentGroup
db schema name	dbo
db table name	DimDepartmentGroup
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
DepartmentGroupKey	False	DepartmentGroupKey	Int32	0	True	True	0	1				DepartmentGroupKey
ParentDepartmentGroupKey	True	ParentDepartmentGroupKey	Int32	1	False							ParentDepartmentGroupKey
DepartmentGroupName	True	DepartmentGroupName	String	2	False					50		DepartmentGroupName

References

parent column	child column	relation name	nested
dbo_DimDepartmentGroup.	dbo_DimDepartmentGroup.	FK_DimDepartmentGroup_DimDepartmentGroup	False

Referenced by

parent column	child column	relation name	nested
dbo_DimDepartmentGroup.	dbo_DimDepartmentGroup.	FK_DimDepartmentGroup_DimDepartmentGroup	False

Foreign key graph

dbo_DimDepartmentGroupdbo_DimDepartmentGroup dbo_DimDepartmentGroupdbo_FactFinance

Dependency graph

Adventure Works DWdbo_DimDepartmentGroup

Objects that dbo_DimDepartmentGroup depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Documentation generated by SqlSpec