Generated using SQL Data Dictionary demo version.


Table Person.EmailAddress (19,972 rows)


Where to send a person email.


  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
PK EmailAddressID int X
Primary key. ID of this email address.
EmailAddress nvarchar(50) X
E-mail address for the person.
rowguid uniqueidentifier newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References:


Used by: