Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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:
© 2015 Microsoft