# Table: BusinessEntityAddress

## Properties

Property | Value
--- | ---
Name | BusinessEntityAddress
ID | 389576426
Owner | dbo
Schema | Person
Filegroup | PRIMARY
Data Size (KB) | 880 KB
Index Size (KB) | 1264 KB
Rows | 19614
Unused (KB) | 320 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:38 PM
Create Date | 8/8/2010 5:21:47 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Cross-reference table mapping customers, vendors, and employees to their addresses.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | BusinessEntityID | int |  |  |
2 | AddressID | int |  |  |
3 | AddressTypeID | int |  |  |
4 | rowguid | uniqueidentifier |  |  |
5 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
BusinessEntityID
AddressID
AddressTypeID

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_BusinessEntityAddress_Address_AddressID | Person.Address | No action | No action
FK_BusinessEntityAddress_AddressType_AddressTypeID | Person.AddressType | No action | No action
FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID | Person.BusinessEntity | No action | No action

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_BusinessEntityAddress_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_BusinessEntityAddress_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID | CLUSTERED |  |  |  |  |
AK_BusinessEntityAddress_rowguid | NONCLUSTERED |  |  |  |  |
IX_BusinessEntityAddress_AddressID | NONCLUSTERED |  |  |  |  |
IX_BusinessEntityAddress_AddressTypeID | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

No referencing tables defined.

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID | Aug 8 2010 5:22PM | 19614 | 19614 | 20 | 0.9988254 | 12 |  |  | 19614

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
5.107513E-05 | 4 | BusinessEntityID
5.098399E-05 | 8 | BusinessEntityID, AddressID
5.098399E-05 | 12 | BusinessEntityID, AddressID, AddressTypeID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
200 | 198 | 1 | 198 | 1
332 | 110 | 2 | 110 | 1
430 | 48 | 2 | 48 | 1
1712 | 656 | 1 | 647 | 1.01391
1776 | 63 | 1 | 63 | 1
1906 | 63 | 1 | 63 | 1
2398 | 63 | 1 | 63 | 1
2996 | 597 | 2 | 597 | 1
4073 | 1076 | 2 | 1076 | 1
4388 | 314 | 2 | 314 | 1
5124 | 735 | 2 | 735 | 1
5479 | 354 | 2 | 354 | 1
5561 | 81 | 2 | 81 | 1
5668 | 106 | 2 | 106 | 1
5976 | 307 | 2 | 307 | 1
10781 | 4806 | 2 | 4804 | 1.000416
20759 | 9989 | 2 | 9977 | 1.001203
20776 | 16 | 1 | 16 | 1
20777 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_BusinessEntityAddress_rowguid | Aug 8 2010 5:23PM | 19614 | 19614 | 107 | 1 | 28 |  |  | 19614

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
5.098399E-05 | 16 | rowguid
5.098399E-05 | 20 | rowguid, BusinessEntityID
5.098399E-05 | 24 | rowguid, BusinessEntityID, AddressID
5.098399E-05 | 28 | rowguid, BusinessEntityID, AddressID, AddressTypeID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
55427f9d-3232-49ed-95b6-00039a561298 | 0 | 1 | 0 | 1
6cb30038-53c3-4d3c-9f16-0138b88b0826 | 94 | 1 | 94 | 1
62574e99-930c-440e-bdcb-021b047e04fe | 61 | 1 | 61 | 1
df6c790a-282c-4fb9-b076-02d1825c513e | 41 | 1 | 41 | 1
2a0476bd-5f2e-49e5-af8f-0661cfb2d0ff | 255 | 1 | 255 | 1
75c5c433-4bf1-4f67-ac8f-07d97e481b1b | 127 | 1 | 127 | 1
57a26ebc-96a1-422e-aa1e-0ab9149f67c7 | 223 | 1 | 223 | 1
bb6812d0-d737-481a-9b36-0eafcc25a8b2 | 255 | 1 | 255 | 1
7362e6fb-292e-4ad3-b4d9-0fd723107239 | 95 | 1 | 95 | 1
65d65040-4c26-4de2-ab92-113d7ee47f23 | 127 | 1 | 127 | 1
10f83864-6a1c-4e22-aac7-139d16fda754 | 159 | 1 | 159 | 1
e15d1129-79fe-4c5a-9dc8-14524b0904ec | 63 | 1 | 63 | 1
08dee9b0-567d-42b4-8c00-196e01b380ae | 383 | 1 | 383 | 1
bb2aadfc-435a-4a20-80b5-1af5f909deb9 | 127 | 1 | 127 | 1
f6b35c94-0e28-41c6-b644-1d863f375922 | 191 | 1 | 191 | 1
6a0b9426-caf4-4ac8-9ef8-1e3bf1d35e44 | 63 | 1 | 63 | 1
0ba04fab-f847-45ec-9d2e-23618758084e | 383 | 1 | 383 | 1
07a37b25-a5a4-4bb2-a3ba-253d8b41328f | 159 | 1 | 159 | 1
b0c5e017-4635-48ce-ba6c-2804d5ff82b6 | 191 | 1 | 191 | 1
d552d6e1-a37e-47ff-938a-2ae093a1aa5b | 223 | 1 | 223 | 1
a384aab4-ab1e-4fa6-bc56-2c8db73d17dc | 159 | 1 | 159 | 1
777e4845-0864-476a-8fce-31682dbba836 | 351 | 1 | 351 | 1
18fa9981-7853-4490-8d2f-325c68be2026 | 63 | 1 | 63 | 1
85bbb247-03e4-4857-94bf-3b5b57c719ca | 671 | 1 | 671 | 1
39f39183-7df1-4fd8-ae0c-3c87a706186d | 95 | 1 | 95 | 1
0f618afc-0d4d-4b11-b695-3d7d03b0f9e1 | 63 | 1 | 63 | 1
0884d4e0-f8b8-4adb-9a26-41384328db41 | 287 | 1 | 287 | 1
cd0268b9-438d-4116-ba5a-4307a8478d8f | 159 | 1 | 159 | 1
27639da0-3bad-4c58-99b3-445f01c39584 | 95 | 1 | 95 | 1
872d0772-508c-4f7b-97b2-45e69d1fa861 | 127 | 1 | 127 | 1
1464dc56-9e4e-46a8-b3f5-47f0f2d3232e | 127 | 1 | 127 | 1
0b28e2c2-71a2-4c10-8330-4ac6a181abc5 | 223 | 1 | 223 | 1
b65f2274-3b0a-48e4-ba7e-4bba50898649 | 63 | 1 | 63 | 1
698ad8d4-579c-43e5-a4ea-4eec543a04a8 | 255 | 1 | 255 | 1
f4416504-45dd-4a49-abc5-503e72a76203 | 95 | 1 | 95 | 1
b623eaa4-7fdf-4b58-9bce-51c50a606fa2 | 127 | 1 | 127 | 1
6c76ebe6-aa86-45e0-868a-525d35eec90e | 63 | 1 | 63 | 1
eec306aa-95b0-4d01-b4c7-53bc4a61ee1a | 127 | 1 | 127 | 1
bcc996f4-9f93-46f4-9b12-556ec87a754f | 127 | 1 | 127 | 1
ae5cb1c2-a319-4473-a88f-566c9c3c6296 | 63 | 1 | 63 | 1
f3b5c00d-7044-41c5-8383-57a0c445151e | 127 | 1 | 127 | 1
d6b3db9b-3dda-45c7-8aa7-5920edde93de | 127 | 1 | 127 | 1
124e7e22-fd8a-4a28-bad4-59cc2713f47e | 63 | 1 | 63 | 1
7a3f6bd8-2ef9-4559-b85a-5d41ded1b159 | 255 | 1 | 255 | 1
4699b525-3b26-4f18-ac18-6139175d7f1a | 319 | 1 | 319 | 1
e9c8b7fb-1fc7-4d89-bcd5-64bac6d2e967 | 255 | 1 | 255 | 1
ff48cca2-77f5-4f37-b523-654371f22869 | 63 | 1 | 63 | 1
29f65068-a634-4797-a5c5-66204c955332 | 63 | 1 | 63 | 1
bbce427c-a289-41f8-8733-677f9e70d09c | 127 | 1 | 127 | 1
a7076e0a-331d-4685-b80e-6a6dce44e58d | 191 | 1 | 191 | 1
7180bedd-df8d-4d48-92bf-6b274eb53f7a | 63 | 1 | 63 | 1
134ab81e-9700-4d4f-a543-6cbce402e6ff | 127 | 1 | 127 | 1
b6bb2f56-3b9c-4843-aa57-6e7f260a8391 | 127 | 1 | 127 | 1
3b140892-cb8e-4b06-bce7-700ee596cf6a | 127 | 1 | 127 | 1
d6509fa5-64a0-4c2a-8e7d-7520e112a5f0 | 383 | 1 | 383 | 1
db83bcb8-214f-4b20-92c8-75d4b982a134 | 63 | 1 | 63 | 1
e4845e1c-9781-4a5f-8f0d-76aec24222aa | 63 | 1 | 63 | 1
766a8351-bf79-4f88-82d0-776196bfb0c8 | 63 | 1 | 63 | 1
402ba642-4c59-4dd1-a2b9-79329db08319 | 127 | 1 | 127 | 1
4b137af2-b3a9-4d77-a678-7aba121286a7 | 127 | 1 | 127 | 1
fdd8e272-37ea-4f7f-8826-7b9fcc5f9b76 | 63 | 1 | 63 | 1
7bbdf5a8-aeae-4112-aaa4-814b6b265435 | 447 | 1 | 447 | 1
df6f5c7d-fafe-4365-84dc-83d74a5b4970 | 191 | 1 | 191 | 1
e0c99275-0a9e-4fb1-93b1-848d21505ae0 | 63 | 1 | 63 | 1
81d37f5b-9159-409d-a5e6-881c8036dd12 | 255 | 1 | 255 | 1
dac69273-74df-4aa5-8881-8a6969e25852 | 191 | 1 | 191 | 1
2b95dccd-395c-4bf7-9fb8-8b51d9dbd6d6 | 63 | 1 | 63 | 1
67ba9276-7594-4d42-b361-8c59f4541e10 | 63 | 1 | 63 | 1
8c9cf50a-3f9a-4676-be79-8d078673d3f3 | 63 | 1 | 63 | 1
4fd3a574-162e-43b7-848c-9041b75138b3 | 255 | 1 | 255 | 1
8101dcc5-99cd-4e2b-ae19-911d68108232 | 63 | 1 | 63 | 1
08201b41-c1d6-4388-8868-91dc49917682 | 63 | 1 | 63 | 1
686461b5-6711-4e2e-9f2c-92f554b5e370 | 63 | 1 | 63 | 1
5bec90ba-880b-475d-a8b3-94690f4bf6b1 | 127 | 1 | 127 | 1
8623348c-e6da-44c0-b185-9c591f566acb | 575 | 1 | 575 | 1
5c380f2d-b69b-4c5b-b159-9f21e8fef1df | 191 | 1 | 191 | 1
f2fbd361-f574-49b3-ab01-a05cc1d97efe | 95 | 1 | 95 | 1
3c931ae3-a0c8-476a-892e-a9b5e119386d | 671 | 1 | 671 | 1
29a3e1da-c928-49ec-a7ed-abeceedef8a3 | 191 | 1 | 191 | 1
405fefe0-5f1b-4d17-a4cf-ae7682d2cdaf | 191 | 1 | 191 | 1
d2f61323-7b12-484f-9a74-afe030286426 | 95 | 1 | 95 | 1
095aab0e-ad22-4363-abbd-b207cc6a850f | 191 | 1 | 191 | 1
91d6644a-7019-4b34-8c53-b6db2effe990 | 383 | 1 | 383 | 1
5616af21-a766-44a3-b442-b7e95884405f | 95 | 1 | 95 | 1
f88d1139-1e0c-4c97-a6e9-b9244033e435 | 95 | 1 | 95 | 1
0bb40d75-dd80-4c24-bef9-ba991d13768e | 95 | 1 | 95 | 1
9c8d0245-57cf-4684-b435-bf03d28b8a2e | 351 | 1 | 351 | 1
cccde7cb-6a24-4770-bdcc-c5a46eb3a714 | 511 | 1 | 511 | 1
fb030920-849c-45a5-b5a9-c789ddef2e84 | 127 | 1 | 127 | 1
3131ac81-678e-48f0-9038-c9190dc5c5e3 | 127 | 1 | 127 | 1
08198768-5a31-4605-8043-d2495ab40697 | 639 | 1 | 639 | 1
2919880b-8b32-4fc8-b7d2-d44fc2d86bcb | 127 | 1 | 127 | 1
044b88e3-7f05-4dab-abf5-d5c5f64a5423 | 127 | 1 | 127 | 1
ebd3b1bb-32fc-4ce2-8bdf-d7ad4801c143 | 127 | 1 | 127 | 1
8aa8e5d9-e329-480d-8be4-daee48f961cc | 255 | 1 | 255 | 1
3c4c6784-a5ed-46d7-bd75-e071e3d5f7fa | 383 | 1 | 383 | 1
c0a75a10-33ad-42d7-a991-e4fde959fbba | 383 | 1 | 383 | 1
3cbced49-9bf1-40be-9c17-e64e2ed0b357 | 127 | 1 | 127 | 1
774dc7df-04eb-4bd5-a459-e842c6e8dfe9 | 127 | 1 | 127 | 1
00ea05ba-de40-47d2-af90-ed4967807e9f | 383 | 1 | 383 | 1
ef4ba5cc-2ec1-4f90-96e0-f035fb02ed7c | 255 | 1 | 255 | 1
3b0645df-0152-463d-b954-f5504f3460b8 | 383 | 1 | 383 | 1
5b15e806-c999-449c-b96d-f6d0a6d5a935 | 127 | 1 | 127 | 1
0f582ab2-5a7b-40c5-96f7-f896c5c5e95b | 127 | 1 | 127 | 1
99784b14-c2de-4c54-8295-fa02ed718f28 | 127 | 1 | 127 | 1
27f68996-ea62-43be-845c-fffa35469e22 | 436 | 1 | 436 | 1
badb6e43-66b8-4561-8b12-ffff3021fc86 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
IX_BusinessEntityAddress_AddressID | Aug 8 2010 5:23PM | 19614 | 19614 | 5 | 1 | 12 |  |  | 19614

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
5.098399E-05 | 4 | AddressID
5.098399E-05 | 8 | AddressID, BusinessEntityID
5.098399E-05 | 12 | AddressID, BusinessEntityID, AddressTypeID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
1064 | 1062 | 1 | 1062 | 1
11446 | 95 | 1 | 95 | 1
29846 | 18399 | 1 | 18399 | 1
32521 | 53 | 1 | 53 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
IX_BusinessEntityAddress_AddressTypeID | Aug 8 2010 5:23PM | 19614 | 19614 | 3 | 0 | 12 |  |  | 19614

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.3333333 | 4 | AddressTypeID
5.098399E-05 | 8 | AddressTypeID, BusinessEntityID
5.098399E-05 | 12 | AddressTypeID, BusinessEntityID, AddressID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
2 | 0 | 18774 | 0 | 1
3 | 0 | 805 | 0 | 1
5 | 0 | 35 | 0 | 1

## Objects that depend on [BusinessEntityAddress]

- Person.BusinessEntityAddress
  - HumanResources.vEmployee
  - Purchasing.vVendorWithAddresses
  - Sales.vIndividualCustomer
  - Sales.vSalesPerson
  - Sales.vStoreWithAddresses

## Objects on which [BusinessEntityAddress] depends

- Person.BusinessEntityAddress
  - Person.Address
    - Person.StateProvince
      - Sales.SalesTerritory
        - Person.CountryRegion
          - dbo.Name
      - dbo.Flag
  - Person.AddressType
  - Person.BusinessEntity

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Person].[BusinessEntityAddress]( [BusinessEntityID] [int] NOT NULL, [AddressID] [int] NOT NULL, [AddressTypeID] [int] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to BusinessEntity.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityAddress', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to Address.AddressID.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityAddress', @level2type=N'COLUMN',@level2name=N'AddressID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to AddressType.AddressTypeID.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityAddress', @level2type=N'COLUMN',@level2name=N'AddressTypeID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityAddress', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityAddress', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference table mapping customers, vendors, and employees to their addresses.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityAddress'

#### See also

List of Tables