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. |
See Also
Reference
Address Table (AdventureWorks)
CustomerAddress Table (AdventureWorks)
Employee Table (AdventureWorks)
VendorAddress Table (AdventureWorks)
Concepts
EmployeeAddress Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary