Address Table (AdventureWorks)
Contains address information of all Adventure Works Cycles customers, vendors, and employees. Customers and vendors can have more than one address. For example, a customer might have separate billing and shipping addresses.
The Address table is contained in the Person schema.
Primary key for address rows.
First street-address line.
Second street address line.
Name of the city.
Unique identification number for the state or province. Foreign key to StateProvince.StateProvinceID.
Postal code for the street address.
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
Date and time the row was last updated.