Export (0) Print
Expand All
Expand Minimize

AddressType Table (AdventureWorks)

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft