Database reference - Adventure Works DW

Table - dbo_DimProductSubcategory

Table properties

name	value
name	dbo_DimProductSubcategory
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimProductSubcategory
db schema name	dbo
db table name	DimProductSubcategory
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
ProductSubcategoryKey	False	ProductSubcategoryKey	Int32	0	True	True	0	1				ProductSubcategoryKey
ProductSubcategoryAlternateKey	True	ProductSubcategoryAlternateKey	Int32	1	False							ProductSubcategoryAlternateKey
EnglishProductSubcategoryName	False	EnglishProductSubcategoryName	String	2	False					50		EnglishProductSubcategoryName
SpanishProductSubcategoryName	False	SpanishProductSubcategoryName	String	3	False					50		SpanishProductSubcategoryName
FrenchProductSubcategoryName	False	FrenchProductSubcategoryName	String	4	False					50		FrenchProductSubcategoryName
ProductCategoryKey	True	ProductCategoryKey	Int32	5	False							ProductCategoryKey

References

parent column	child column	relation name	nested
dbo_DimProductCategory.	dbo_DimProductSubcategory.	FK_DimProductSubcategory_DimProductCategory	False

Referenced by

parent column	child column	relation name	nested
dbo_DimProductCategory.	dbo_DimProductSubcategory.	FK_DimProductSubcategory_DimProductCategory	False

Foreign key graph

dbo_DimProductCategorydbo_DimProductSubcategory dbo_DimProduct

Dependency graph

Adventure Works DWdbo_DimProductSubcategory

Objects that dbo_DimProductSubcategory depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Documentation generated by SqlSpec