AddressType Table (AdventureWorks)

Is a lookup table that defines the customer, vendor, or employee address type such as billing, shipping, or primary.

AddressType Table Definition

The AddressType table is contained in the Person schema.

Column

Data type

Nullability

Description

AddressTypeID

int

Not null

Primary key for AddressType rows.

Name

Name (user-defined type)

nvarchar(50)

Not null

Address type description. For example, billing, home, or shipping.

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.