Store Table (AdventureWorks)

Contains the customers, the resellers, of Adventure Works products.

Store Table Definition

The Store table is contained in the Sales schema.

Column	Data type	Nullability	Description
CustomerID	int	Not null	Primary key. Foreign key to Customer.CustomerID.
Name	Name (user-defined type) nvarchar(50)	Not null	Name of the store.
SalesPersonID	int	Null	ID of the Adventure Works sales representative responsible for selling products to the store. Foreign key to SalesPerson.SalesPersonID.
Demographics	xml	Null	Demographic information about the store such as the number of employees, annual sales and store type. For more information, see About the Store.Demographics xml Column.
rowguid	uniqueidentifier	Not null	ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not Null	Date and time the row was last updated.

See Also

Reference

Contact Table (AdventureWorks)

Customer Table (AdventureWorks)

SalesOrderDetail Table (AdventureWorks)

SalesOrderHeader Table (AdventureWorks)

StoreContact Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary