Database reference - AmoAdventureWorks

Table - DimProductSubcategory

Table properties

name	value
name	DimProductSubcategory
data source view	AdventureWorksDW
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
ProductSubcategoryAlternateKey	True	ProductSubcategoryAlternateKey	Int32	1	False
EnglishProductSubcategoryName	False	EnglishProductSubcategoryName	String	2	False					50
SpanishProductSubcategoryName	False	SpanishProductSubcategoryName	String	3	False					50
FrenchProductSubcategoryName	False	FrenchProductSubcategoryName	String	4	False					50
ProductCategoryKey	True	ProductCategoryKey	Int32	5	False

References

parent column	child column	relation name	nested
DimProductCategory.	DimProductSubcategory.	FK_DimProductSubcategory_ProductCategoryKey	False

Referenced by

parent column	child column	relation name	nested
DimProductCategory.	DimProductSubcategory.	FK_DimProductSubcategory_ProductCategoryKey	False

Objects that DimProductSubcategory depends on

name	object type	level
AdventureWorksDW	DataSourceView	1
AmoAdventureWorks	Database	2

Documentation generated by SqlSpec