Share 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.