Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Maps employees in the Employee table to their address in the Address table.
EmployeeAddress Table Definition
The EmployeeAddress table is contained in the HumanResources schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
EmployeeID |
int |
Not null |
Employee identification number. Foreign key to Employee.EmployeeID. |
AddressID |
int |
Not null |
Employee address identification number. Foreign key to Address.AddressID. |
rowguid |
uniqueidentifier ROWGUIDCOL |
Not null |
ROWGUIDCOL number that uniquely identifies the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Employee Table (AdventureWorks)
Address Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary