Generated using SQL Data Dictionary demo version.

Table Person.BusinessEntityAddress (19,614 rows)

Cross-reference table mapping customers, vendors, and employees to their addresses.

  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Primary key. Foreign key to BusinessEntity.BusinessEntityID.
PK, FK AddressID int
Primary key. Foreign key to Address.AddressID.
PK, FK AddressTypeID int
Primary key. Foreign key to AddressType.AddressTypeID.
UK 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.



Used by: