Table: 'Sales.Store'

6 fields. 140 bytes.

Customers (resellers) of Adventure Works products.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
CustomerIDint   Not nullPrimary key. Foreign key to Customer.CustomerID. 
NameName nvarchar(50) Not nullName of the store. 
SalesPersonIDint   NullID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID. 
Demographicsxml   NullDemographic informationg about the store such as the number of employees, annual sales and store type. 
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.Store'

Primary Key NameField Name

Foreign keys for table 'Sales.Store', 2 items

ForeignPrimaryKey Name

Indexes for table 'Sales.Store', 3 items

Index NameDescriptionClusteredUniqueFields
PK_Store_CustomerIDClustered index created by a primary key constraint.YesYesCustomerID
AK_Store_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid
IX_Store_SalesPersonIDNonclustered index.NoNoSalesPersonID

Triggers for table 'Sales.Store', 2 items

iStoreAFTER INSERT trigger inserting Store only if the Customer does not exist in the Individual table.after Insert Yes
uStoreAFTER UPDATE trigger setting the ModifiedDate column in the Store table to the current date.after Update Yes

Dependencies for table 'Sales.Store', 3 items

Object NameTypeField Name