Partilhar via


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.

Address Table Definition

The Address table is contained in the Person schema.

Column Data type Nullability Description

AddressID

int

Not null

Primary key for address rows.

AddressLine1

nvarchar(60)

Not null

First street-address line.

AddressLine2

nvarchar(60)

Null

Second street address line.

City

nvarchar(30)

Not null

Name of the city.

StateProvinceID

int

Not null

Unique identification number for the state or province. Foreign key to StateProvince.StateProvinceID.

PostalCode

nvarchar(15)

Not null

Postal code for the street address.

rowguid

uniqueidentifier ROWGUIDCOL

Not null

ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

AddressType Table (AdventureWorks)
CustomerAddress Table (AdventureWorks)
Employee Table (AdventureWorks)
StateProvince Table (AdventureWorks)
VendorAddress Table (AdventureWorks)

Concepts

EmployeeAddress Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance