Export (0) Print
Expand All
Expand Minimize

EmployeeAddress Table (AdventureWorks)

Maps employees in the Employee table to their address in the Address table.

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.

Community Additions

ADD
Show:
© 2015 Microsoft