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