Export (0) Print
Expand All
Expand Minimize

VendorAddress Table (AdventureWorks)

Is a cross-reference table that maps vendors and their addresses. Vendors may have more than one address; for example, a vendor may have separate billing and shipping addresses.

The VendorAddress table is contained in the Purchasing schema.

Column Data type Nullability Description

VendorID

int

Not null

Primary key. Foreign key to Vendor.VendorID.

AddressID

int

Not null

Primary key. Foreign key to Address.AddressID.

AddressTypeID

int

Not null

Address type. Foreign key to AddressType.AddressTypeID.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

Community Additions

ADD
Show:
© 2014 Microsoft