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.

VendorAddress Table Definition

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.

See Also

Reference

Address Table (AdventureWorks)
AddressType Table (AdventureWorks)
Vendor Table (AdventureWorks)
VendorContact Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance