table icon 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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
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 false false false
2 AddressID int false false false
3 AddressTypeID int false false false
4 rowguid uniqueidentifier false false false
5 ModifiedDate datetime false false false

Identity Columns

No identity columns defined.

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID false 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()) false MS_Description Default constraint value of NEWID()
DF_BusinessEntityAddress_ModifiedDate ModifiedDate (getdate()) false 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 true true false false false
AK_BusinessEntityAddress_rowguid NONCLUSTERED false true false false false
IX_BusinessEntityAddress_AddressID NONCLUSTERED false false false false false
IX_BusinessEntityAddress_AddressTypeID NONCLUSTERED false false false false false

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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID Aug 8 2010 5:22PM 19614 19614 20 0.9988254 12 false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_BusinessEntityAddress_rowguid Aug 8 2010 5:23PM 19614 19614 107 1 28 false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_BusinessEntityAddress_AddressID Aug 8 2010 5:23PM 19614 19614 5 1 12 false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_BusinessEntityAddress_AddressTypeID Aug 8 2010 5:23PM 19614 19614 3 0 12 false 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]

Objects on which [BusinessEntityAddress] depends

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