Table: BusinessEntityContact Table: BusinessEntityContact| Property | Value |
|---|---|
| Name | BusinessEntityContact |
| ID | 437576597 |
| Owner | dbo |
| Schema | Person |
| Filegroup | PRIMARY |
| Data Size (KB) | 48 KB |
| Index Size (KB) | 128 KB |
| Rows | 909 |
| Unused (KB) | 0 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 |
| Name | Value |
|---|---|
| MS_Description | Cross-reference table mapping stores, vendors, and employees to people |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | BusinessEntityID | int |
|
|
|
| 2 | PersonID | int |
|
|
|
| 3 | ContactTypeID | int |
|
|
|
| 4 | rowguid | uniqueidentifier |
|
|
|
| 5 | ModifiedDate | datetime |
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| BusinessEntityID |
| PersonID |
| ContactTypeID |
| Name | Referenced Object | Update Action | Delete Action |
|---|---|---|---|
| FK_BusinessEntityContact_Person_PersonID | Person.Person | No action | No action |
| FK_BusinessEntityContact_ContactType_ContactTypeID | Person.ContactType | No action | No action |
| FK_BusinessEntityContact_BusinessEntity_BusinessEntityID | Person.BusinessEntity | No action | No action |
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_BusinessEntityContact_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_BusinessEntityContact_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID | CLUSTERED |
|
|
|
|
|
| AK_BusinessEntityContact_rowguid | NONCLUSTERED |
|
|
|
|
|
| IX_BusinessEntityContact_PersonID | NONCLUSTERED |
|
|
|
|
|
| IX_BusinessEntityContact_ContactTypeID | NONCLUSTERED |
|
|
|
|
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID | Aug 8 2010 5:22PM | 909 | 909 | 200 | 0.9250764 | 12 |
|
909 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001242236 | 4 | BusinessEntityID |
| 0.00110011 | 8 | BusinessEntityID, PersonID |
| 0.00110011 | 12 | BusinessEntityID, PersonID, ContactTypeID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 292 | 0 | 1 | 0 | 1 |
| 298 | 2 | 1 | 2 | 1 |
| 306 | 3 | 1 | 3 | 1 |
| 314 | 3 | 1 | 3 | 1 |
| 322 | 3 | 1 | 3 | 1 |
| 330 | 3 | 1 | 3 | 1 |
| 338 | 3 | 1 | 3 | 1 |
| 346 | 3 | 1 | 3 | 1 |
| 358 | 5 | 1 | 5 | 1 |
| 366 | 3 | 1 | 3 | 1 |
| 374 | 3 | 1 | 3 | 1 |
| 382 | 3 | 1 | 3 | 1 |
| 390 | 3 | 1 | 3 | 1 |
| 398 | 3 | 1 | 3 | 1 |
| 406 | 3 | 1 | 3 | 1 |
| 414 | 3 | 1 | 3 | 1 |
| 426 | 5 | 1 | 5 | 1 |
| 434 | 3 | 1 | 3 | 1 |
| 442 | 3 | 1 | 3 | 1 |
| 450 | 3 | 1 | 3 | 1 |
| 458 | 3 | 1 | 3 | 1 |
| 466 | 3 | 1 | 3 | 1 |
| 474 | 3 | 1 | 3 | 1 |
| 482 | 3 | 1 | 3 | 1 |
| 490 | 3 | 1 | 3 | 1 |
| 498 | 3 | 1 | 3 | 1 |
| 506 | 3 | 1 | 3 | 1 |
| 514 | 3 | 1 | 3 | 1 |
| 526 | 5 | 1 | 5 | 1 |
| 532 | 4 | 2 | 2 | 2 |
| 540 | 3 | 1 | 3 | 1 |
| 550 | 4 | 1 | 4 | 1 |
| 556 | 2 | 2 | 2 | 1 |
| 564 | 3 | 1 | 3 | 1 |
| 572 | 3 | 1 | 3 | 1 |
| 580 | 3 | 1 | 3 | 1 |
| 588 | 3 | 1 | 3 | 1 |
| 596 | 3 | 1 | 3 | 1 |
| 604 | 3 | 1 | 3 | 1 |
| 612 | 3 | 1 | 3 | 1 |
| 620 | 3 | 2 | 3 | 1 |
| 624 | 2 | 2 | 1 | 2 |
| 632 | 3 | 1 | 3 | 1 |
| 640 | 3 | 1 | 3 | 1 |
| 644 | 2 | 2 | 1 | 2 |
| 652 | 3 | 1 | 3 | 1 |
| 660 | 3 | 1 | 3 | 1 |
| 668 | 3 | 1 | 3 | 1 |
| 676 | 3 | 1 | 3 | 1 |
| 684 | 3 | 1 | 3 | 1 |
| 694 | 4 | 1 | 4 | 1 |
| 702 | 3 | 1 | 3 | 1 |
| 714 | 5 | 1 | 5 | 1 |
| 722 | 3 | 1 | 3 | 1 |
| 730 | 3 | 1 | 3 | 1 |
| 738 | 3 | 1 | 3 | 1 |
| 746 | 3 | 1 | 3 | 1 |
| 754 | 3 | 1 | 3 | 1 |
| 762 | 3 | 1 | 3 | 1 |
| 770 | 3 | 1 | 3 | 1 |
| 782 | 5 | 2 | 5 | 1 |
| 786 | 2 | 2 | 1 | 2 |
| 790 | 2 | 2 | 1 | 2 |
| 798 | 3 | 1 | 3 | 1 |
| 806 | 3 | 1 | 3 | 1 |
| 814 | 3 | 1 | 3 | 1 |
| 822 | 3 | 1 | 3 | 1 |
| 830 | 3 | 1 | 3 | 1 |
| 838 | 3 | 1 | 3 | 1 |
| 846 | 3 | 1 | 3 | 1 |
| 854 | 3 | 1 | 3 | 1 |
| 862 | 3 | 1 | 3 | 1 |
| 870 | 3 | 1 | 3 | 1 |
| 878 | 3 | 1 | 3 | 1 |
| 886 | 3 | 1 | 3 | 1 |
| 894 | 3 | 1 | 3 | 1 |
| 902 | 3 | 1 | 3 | 1 |
| 910 | 3 | 1 | 3 | 1 |
| 918 | 3 | 1 | 3 | 1 |
| 926 | 3 | 1 | 3 | 1 |
| 934 | 3 | 1 | 3 | 1 |
| 942 | 3 | 1 | 3 | 1 |
| 950 | 3 | 1 | 3 | 1 |
| 962 | 5 | 1 | 5 | 1 |
| 974 | 5 | 1 | 5 | 1 |
| 986 | 5 | 2 | 5 | 1 |
| 990 | 2 | 2 | 1 | 2 |
| 994 | 2 | 2 | 1 | 2 |
| 998 | 2 | 2 | 1 | 2 |
| 1002 | 2 | 2 | 1 | 2 |
| 1006 | 2 | 2 | 1 | 2 |
| 1010 | 2 | 2 | 1 | 2 |
| 1016 | 4 | 2 | 2 | 2 |
| 1022 | 4 | 2 | 2 | 2 |
| 1028 | 4 | 2 | 2 | 2 |
| 1034 | 2 | 1 | 2 | 1 |
| 1046 | 5 | 1 | 5 | 1 |
| 1052 | 2 | 1 | 2 | 1 |
| 1064 | 5 | 1 | 5 | 1 |
| 1076 | 5 | 1 | 5 | 1 |
| 1082 | 2 | 1 | 2 | 1 |
| 1094 | 5 | 1 | 5 | 1 |
| 1106 | 5 | 1 | 5 | 1 |
| 1118 | 5 | 1 | 5 | 1 |
| 1126 | 3 | 1 | 3 | 1 |
| 1134 | 3 | 1 | 3 | 1 |
| 1142 | 3 | 1 | 3 | 1 |
| 1150 | 3 | 1 | 3 | 1 |
| 1158 | 3 | 1 | 3 | 1 |
| 1166 | 3 | 1 | 3 | 1 |
| 1174 | 3 | 1 | 3 | 1 |
| 1182 | 3 | 1 | 3 | 1 |
| 1190 | 3 | 1 | 3 | 1 |
| 1198 | 3 | 1 | 3 | 1 |
| 1206 | 3 | 1 | 3 | 1 |
| 1214 | 3 | 1 | 3 | 1 |
| 1222 | 3 | 1 | 3 | 1 |
| 1230 | 3 | 1 | 3 | 1 |
| 1238 | 3 | 1 | 3 | 1 |
| 1246 | 3 | 1 | 3 | 1 |
| 1254 | 3 | 1 | 3 | 1 |
| 1262 | 3 | 1 | 3 | 1 |
| 1270 | 3 | 1 | 3 | 1 |
| 1278 | 3 | 1 | 3 | 1 |
| 1286 | 3 | 1 | 3 | 1 |
| 1294 | 3 | 1 | 3 | 1 |
| 1302 | 3 | 1 | 3 | 1 |
| 1310 | 3 | 1 | 3 | 1 |
| 1318 | 3 | 1 | 3 | 1 |
| 1332 | 6 | 2 | 6 | 1 |
| 1340 | 6 | 2 | 3 | 2 |
| 1344 | 2 | 2 | 1 | 2 |
| 1348 | 2 | 2 | 1 | 2 |
| 1352 | 2 | 2 | 1 | 2 |
| 1360 | 6 | 2 | 3 | 2 |
| 1364 | 2 | 1 | 1 | 2 |
| 1372 | 3 | 1 | 3 | 1 |
| 1380 | 3 | 1 | 3 | 1 |
| 1388 | 3 | 1 | 3 | 1 |
| 1396 | 3 | 1 | 3 | 1 |
| 1404 | 3 | 1 | 3 | 1 |
| 1412 | 3 | 1 | 3 | 1 |
| 1420 | 3 | 1 | 3 | 1 |
| 1428 | 3 | 1 | 3 | 1 |
| 1436 | 3 | 1 | 3 | 1 |
| 1444 | 3 | 1 | 3 | 1 |
| 1452 | 3 | 1 | 3 | 1 |
| 1460 | 3 | 1 | 3 | 1 |
| 1468 | 3 | 1 | 3 | 1 |
| 1476 | 3 | 1 | 3 | 1 |
| 1484 | 3 | 1 | 3 | 1 |
| 1492 | 3 | 3 | 3 | 1 |
| 1496 | 2 | 3 | 1 | 2 |
| 1508 | 5 | 3 | 5 | 1 |
| 1516 | 3 | 2 | 3 | 1 |
| 1522 | 2 | 3 | 2 | 1 |
| 1528 | 2 | 3 | 2 | 1 |
| 1536 | 3 | 3 | 3 | 1 |
| 1542 | 4 | 3 | 2 | 2 |
| 1550 | 3 | 1 | 3 | 1 |
| 1554 | 2 | 1 | 1 | 2 |
| 1562 | 3 | 1 | 3 | 1 |
| 1568 | 4 | 3 | 2 | 2 |
| 1576 | 3 | 1 | 3 | 1 |
| 1584 | 3 | 1 | 3 | 1 |
| 1592 | 3 | 1 | 3 | 1 |
| 1596 | 3 | 3 | 1 | 3 |
| 1600 | 1 | 3 | 1 | 1 |
| 1604 | 2 | 3 | 1 | 2 |
| 1616 | 5 | 3 | 5 | 1 |
| 1624 | 3 | 1 | 3 | 1 |
| 1632 | 3 | 1 | 3 | 1 |
| 1640 | 3 | 1 | 3 | 1 |
| 1644 | 3 | 1 | 1 | 3 |
| 1648 | 3 | 3 | 1 | 3 |
| 1652 | 3 | 1 | 1 | 3 |
| 1658 | 3 | 2 | 2 | 1.5 |
| 1664 | 3 | 2 | 2 | 1.5 |
| 1670 | 2 | 3 | 2 | 1 |
| 1680 | 4 | 1 | 4 | 1 |
| 1690 | 4 | 1 | 4 | 1 |
| 1696 | 4 | 1 | 2 | 2 |
| 1798 | 4 | 1 | 2 | 2 |
| 1810 | 5 | 1 | 5 | 1 |
| 1822 | 5 | 1 | 5 | 1 |
| 1834 | 5 | 1 | 5 | 1 |
| 1846 | 5 | 1 | 5 | 1 |
| 1858 | 5 | 1 | 5 | 1 |
| 1870 | 5 | 1 | 5 | 1 |
| 1882 | 5 | 1 | 5 | 1 |
| 1894 | 5 | 1 | 5 | 1 |
| 1906 | 5 | 1 | 5 | 1 |
| 1918 | 5 | 1 | 5 | 1 |
| 1930 | 5 | 1 | 5 | 1 |
| 1942 | 5 | 1 | 5 | 1 |
| 1954 | 5 | 1 | 5 | 1 |
| 1966 | 5 | 1 | 5 | 1 |
| 1980 | 6 | 1 | 6 | 1 |
| 1994 | 6 | 1 | 6 | 1 |
| 2051 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_BusinessEntityContact_rowguid | Aug 8 2010 5:23PM | 909 | 909 | 179 | 1 | 28 |
|
909 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.00110011 | 16 | rowguid |
| 0.00110011 | 20 | rowguid, BusinessEntityID |
| 0.00110011 | 24 | rowguid, BusinessEntityID, PersonID |
| 0.00110011 | 28 | rowguid, BusinessEntityID, PersonID, ContactTypeID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| d785338c-b481-440d-888a-002893490281 | 0 | 1 | 0 | 1 |
| e6acfc71-cfa1-4421-9fd3-021afadfcd83 | 6 | 1 | 6 | 1 |
| 4da9bf5d-10cb-468f-991c-03f2a823e19e | 3 | 1 | 3 | 1 |
| dc3917c4-7100-41b2-b616-04d2a262f91f | 3 | 1 | 3 | 1 |
| 57c23006-ecd9-4a43-ab70-065c0a7a195d | 3 | 1 | 3 | 1 |
| 01422957-23ae-4079-afba-07000f64b4a1 | 3 | 1 | 3 | 1 |
| 0d3b502b-ef37-465f-bec4-08a6b443ad19 | 3 | 1 | 3 | 1 |
| d78842cd-a022-4c78-9e05-0a8388b95ae3 | 3 | 1 | 3 | 1 |
| 4a36fdb7-af34-4691-88cf-0b6ccc8e7b2c | 3 | 1 | 3 | 1 |
| 68b220b0-e15d-4ba3-903c-0e416b580747 | 13 | 1 | 13 | 1 |
| 488b7fd6-4b8c-4e95-b3c4-0f54c0f2427c | 3 | 1 | 3 | 1 |
| f687da08-9726-4ccb-9cb5-11762801f940 | 5 | 1 | 5 | 1 |
| 5b35e833-a240-48c1-a16a-13f179a06be5 | 3 | 1 | 3 | 1 |
| 445389b9-e18d-4276-8823-14fe5deea518 | 7 | 1 | 7 | 1 |
| 1ed9a194-a171-4ed2-809a-15c5d979ae1f | 3 | 1 | 3 | 1 |
| 33c0a355-14a1-4159-931d-17437219804e | 3 | 1 | 3 | 1 |
| df46ea08-dfd7-45f9-9d33-1ac3f0678426 | 3 | 1 | 3 | 1 |
| dc638543-d8a6-45bb-9ed4-1ba1b9afaaf5 | 3 | 1 | 3 | 1 |
| 5c23420e-fd71-4b4d-9b11-1e657f6ac940 | 7 | 1 | 7 | 1 |
| 41e68189-db5b-40dc-b0c7-1ee9076869df | 3 | 1 | 3 | 1 |
| 9d878d12-23e7-435b-a5a6-2006f7bd13c0 | 5 | 1 | 5 | 1 |
| 01bec60c-8e17-4c63-a787-2245e92a8845 | 5 | 1 | 5 | 1 |
| 364733c3-1e75-4461-befb-23978a20bb8e | 3 | 1 | 3 | 1 |
| 181f0fb6-6b52-44df-a11f-24abee092248 | 7 | 1 | 7 | 1 |
| c8606945-354c-49fe-8152-2733276cd554 | 3 | 1 | 3 | 1 |
| 661f5c8d-b702-4eea-a01a-27c626f441ff | 3 | 1 | 3 | 1 |
| 1baa8527-0808-47cf-8da3-29bfde65ca13 | 7 | 1 | 7 | 1 |
| 32752ac6-b62d-4a89-a0de-2b50c69fc1ab | 7 | 1 | 7 | 1 |
| 0f5eab63-64c3-4611-b812-2ca4dd1d0d31 | 5 | 1 | 5 | 1 |
| d6ad717a-69b7-4bfe-a678-2e48d4041cbe | 3 | 1 | 3 | 1 |
| f79a3fb8-9ac4-451c-a1c7-30353a6aa388 | 3 | 1 | 3 | 1 |
| de81bf7a-15c0-4923-bba9-3209ad60c1d3 | 5 | 1 | 5 | 1 |
| 63bd791b-4a5f-4ea4-888e-327536b4f5a3 | 3 | 1 | 3 | 1 |
| 6f7c73fd-64c8-4737-9b22-32e866423c86 | 3 | 1 | 3 | 1 |
| 116fc6f2-a3d9-4bb7-8368-34bfa8c1239f | 3 | 1 | 3 | 1 |
| 33b4da81-4448-481f-bf7c-357ea4d23f21 | 3 | 1 | 3 | 1 |
| cb38a0dc-d66a-473e-9f51-379236c52c61 | 3 | 1 | 3 | 1 |
| 2fb2d98f-00ac-4cfc-9802-38ffad872941 | 5 | 1 | 5 | 1 |
| ff13563a-7230-49b7-ad27-3a36153340e0 | 3 | 1 | 3 | 1 |
| b11e92d1-4857-44d1-9dbb-3b7ac268a168 | 3 | 1 | 3 | 1 |
| aaf2bde5-2c4f-4c5a-91a1-3c2b0f9314a8 | 3 | 1 | 3 | 1 |
| f0a14131-68ec-49a5-9489-3dd6c8b1ad73 | 3 | 1 | 3 | 1 |
| 2c74a535-91b7-489c-b9de-3e54b101952e | 3 | 1 | 3 | 1 |
| e7784bf8-4f12-4916-947f-3f1f08d22189 | 3 | 1 | 3 | 1 |
| 35a4367b-4da3-40d4-bb4f-40f3aa063c6f | 3 | 1 | 3 | 1 |
| ede3c846-d97e-4114-a84e-4264bd988224 | 7 | 1 | 7 | 1 |
| 2d560d09-efbf-44a0-b2f8-42d2427384f9 | 3 | 1 | 3 | 1 |
| 2ee6ddcb-2dd3-48a1-a4ff-440e16a4dfbc | 3 | 1 | 3 | 1 |
| 2ec86f59-58c2-45f5-b2aa-44711df20923 | 3 | 1 | 3 | 1 |
| 37083d2d-4664-442c-8efe-4593175342ac | 5 | 1 | 5 | 1 |
| 76c9f93d-a802-46d0-8b55-4650128ff842 | 3 | 1 | 3 | 1 |
| e58b9638-0524-4598-95ad-471c1025eaa9 | 3 | 1 | 3 | 1 |
| 87df53aa-98a9-4123-9d08-476ec2ea1786 | 3 | 1 | 3 | 1 |
| 77648ffd-ea61-4cb8-b173-48c3730c1586 | 3 | 1 | 3 | 1 |
| 2aba1a33-ab77-4fa6-aa84-494ffa2870e8 | 5 | 1 | 5 | 1 |
| 141738f6-addf-43af-8b88-4c0cdb088608 | 9 | 1 | 9 | 1 |
| 065da222-4b01-49b8-9834-4c82144b1c62 | 3 | 1 | 3 | 1 |
| 51b4ee63-df9c-4de0-940d-4e5938ff8d18 | 3 | 1 | 3 | 1 |
| 4ff4e821-6317-4fd7-97c9-503e01e6f03b | 3 | 1 | 3 | 1 |
| 6ca86e4e-fdab-4403-96d0-55750f18673b | 13 | 1 | 13 | 1 |
| c894e876-52df-4299-a5c7-56767f30f1d7 | 3 | 1 | 3 | 1 |
| 88dba5d8-56e8-48af-b6a1-56fc167fd434 | 3 | 1 | 3 | 1 |
| 4e02665b-5003-48db-b88a-589a1405f133 | 5 | 1 | 5 | 1 |
| 50b18240-4537-41fe-a57c-5955ce10f9a9 | 3 | 1 | 3 | 1 |
| e0fe5c1e-8ede-4fef-94f3-5ac025a62ca3 | 5 | 1 | 5 | 1 |
| 21a138c7-a5bb-4c44-a4a1-5b44a37e0ef1 | 3 | 1 | 3 | 1 |
| df097ff6-7d33-4756-8adf-5d3e95aad1f0 | 7 | 1 | 7 | 1 |
| 8c6dc1f4-5a7b-4ea1-98f0-5eb866b396a0 | 7 | 1 | 7 | 1 |
| 7a98d967-5a47-499c-ac2e-612f40d0df17 | 5 | 1 | 5 | 1 |
| 745dcf49-1142-459c-9815-6247a4e60122 | 3 | 1 | 3 | 1 |
| 8efca0a9-3459-4e6e-8a50-63c3a8f9e090 | 3 | 1 | 3 | 1 |
| 9f87a169-3943-4b84-bb4b-645a3c1b491a | 3 | 1 | 3 | 1 |
| c7bbf9ba-a676-41ad-adc0-64a3190a50af | 3 | 1 | 3 | 1 |
| 16a22928-db85-4248-9bf4-67b3f04638e5 | 3 | 1 | 3 | 1 |
| 0d84e8c6-ae2b-402d-aaec-68000389836c | 3 | 1 | 3 | 1 |
| c9acb2c5-8dca-405c-8084-6a5d8c1633f9 | 11 | 1 | 11 | 1 |
| 45456658-cf0e-4bbb-b716-6cf97c14d239 | 3 | 1 | 3 | 1 |
| d3e78be5-943f-42b2-a4ac-6ead58dda63c | 4 | 1 | 4 | 1 |
| 79f35c92-5e55-4f57-babe-6f45793fb644 | 3 | 1 | 3 | 1 |
| 080a7c86-10a9-4f4a-9370-701e5648bf6c | 3 | 1 | 3 | 1 |
| f17ff8e0-37d9-4a21-9375-719f9cb4d82e | 3 | 1 | 3 | 1 |
| 0022434c-e325-47b0-92a0-7302ffa5046f | 3 | 1 | 3 | 1 |
| e00492ef-c073-4668-b79a-74d66ac5f54f | 3 | 1 | 3 | 1 |
| 52fd88bf-3ddd-4e53-8a93-75785338a7fd | 3 | 1 | 3 | 1 |
| c55b9abe-b213-4840-bcf8-770e014a3ce0 | 3 | 1 | 3 | 1 |
| 0e667419-c7bb-4aba-be17-78801a6d929c | 3 | 1 | 3 | 1 |
| 1d792b21-9718-4388-b743-79363b98c66f | 3 | 1 | 3 | 1 |
| 6d74361b-1ed2-4710-91ca-7a10872733cc | 3 | 1 | 3 | 1 |
| c6f04c9e-c446-423e-bb29-7c1a3955ed4f | 7 | 1 | 7 | 1 |
| 08658234-8fb7-4ca8-a175-7d25bf2d279d | 3 | 1 | 3 | 1 |
| 5649315a-2e88-4005-8067-7fadb163cbb4 | 3 | 1 | 3 | 1 |
| d47e35e9-fcfe-4bf6-a6c0-8061a65a751f | 3 | 1 | 3 | 1 |
| 9538671b-4cb6-48aa-b31d-81ebd402309c | 3 | 1 | 3 | 1 |
| f3e2d6c6-b0bc-4f03-8c35-8251b0f0081f | 3 | 1 | 3 | 1 |
| 1873f5d1-1cd7-4276-9c77-84a563ab80da | 7 | 1 | 7 | 1 |
| 1535056c-1eb5-4da5-bf9b-85d25c6fcbfb | 3 | 1 | 3 | 1 |
| 453f76b0-93ba-4dbd-bfec-8824decdc1c7 | 3 | 1 | 3 | 1 |
| 313fbabd-b608-4e82-a327-8971f777febe | 3 | 1 | 3 | 1 |
| 2c05b4d5-2a9c-4225-9a69-8a545c210fce | 3 | 1 | 3 | 1 |
| 843791b6-9b34-485c-9667-8be19df02935 | 3 | 1 | 3 | 1 |
| a4e5551f-c96a-453e-9c79-8ee38ddeb181 | 7 | 1 | 7 | 1 |
| 52d5d2a5-7e95-4591-a11b-90b8862a683b | 3 | 1 | 3 | 1 |
| 63e6f8f0-1929-448c-ae9c-91be8b356d4f | 3 | 1 | 3 | 1 |
| 54c620e3-027d-48e7-8568-92b00609ad78 | 3 | 1 | 3 | 1 |
| 2e4d090f-9e65-479b-b021-93ad772cd346 | 3 | 1 | 3 | 1 |
| 4dec0d48-8fc4-42f3-808a-9534e0209eb6 | 3 | 1 | 3 | 1 |
| 2f00d749-df30-452a-ab1a-969d78012ae1 | 3 | 1 | 3 | 1 |
| 3634dd7d-1d9b-4332-a736-96fe49da5523 | 3 | 1 | 3 | 1 |
| 8f1dcb97-59c5-41bb-a0c4-97bf19059c0f | 3 | 1 | 3 | 1 |
| 38820d45-9182-4bdb-a272-98a6bd996bf1 | 3 | 1 | 3 | 1 |
| bc4e0302-33e6-4897-995e-9994bebfaeb6 | 3 | 1 | 3 | 1 |
| 4845412c-a5f9-4647-ae10-9d50904a289b | 7 | 1 | 7 | 1 |
| da33b75d-32fb-432d-a275-9e9d32e78f3e | 3 | 1 | 3 | 1 |
| 619400f2-f097-480d-a171-9f6f4cd0043c | 3 | 1 | 3 | 1 |
| 4020deae-56f6-47df-96c1-a01f3de2305c | 3 | 1 | 3 | 1 |
| 38f5defb-b56b-46ab-b1f8-a18b6c828dbe | 3 | 1 | 3 | 1 |
| e9abd738-dd0b-4cd4-af1c-a30395eab63b | 3 | 1 | 3 | 1 |
| 45e39004-8430-4ad6-a8c5-a49eabe23ad1 | 3 | 1 | 3 | 1 |
| bc5d2e56-3018-4564-9953-a5a036522409 | 3 | 1 | 3 | 1 |
| 7d4d2dbc-4a44-48f5-911d-a63abafd5120 | 3 | 1 | 3 | 1 |
| 9fcf7e19-24c1-4b71-a5f0-a6bb130ecda2 | 3 | 1 | 3 | 1 |
| e02807d5-07be-41d1-b609-a7f5117b42d2 | 3 | 1 | 3 | 1 |
| bcd5ad34-36e0-4662-bf7a-a928a0e30084 | 3 | 1 | 3 | 1 |
| 5b1b9196-4275-46ba-88c0-a9d6ff1d8cee | 3 | 1 | 3 | 1 |
| 2b9190e9-8aeb-4a2b-a890-aafe2e25b3f0 | 3 | 1 | 3 | 1 |
| 6010b9ef-f741-4618-91a0-ac516a0a8b3a | 3 | 1 | 3 | 1 |
| 25cd8c2c-375f-4267-bf52-acce99255b42 | 3 | 1 | 3 | 1 |
| 13288046-411f-4220-844d-aece22fc91c1 | 3 | 1 | 3 | 1 |
| 670d9c39-a2a8-47fa-bbb6-b01a014b8e95 | 7 | 1 | 7 | 1 |
| 780c7b10-7d06-4ee4-b5a8-b1a93d85d05c | 7 | 1 | 7 | 1 |
| c43c374c-0343-47ce-b5bc-b25dd5e86c1a | 3 | 1 | 3 | 1 |
| 3899b7d6-f35b-4b34-a532-b300ed44e77c | 3 | 1 | 3 | 1 |
| 02039e2b-5f88-452a-bb2d-b3c4446de3c8 | 3 | 1 | 3 | 1 |
| 451bbf82-4466-40f7-ac33-b599b9d488c5 | 3 | 1 | 3 | 1 |
| 49d1c883-cd61-4279-9192-b8a3d371514a | 7 | 1 | 7 | 1 |
| fbb75991-e5e9-40c1-b04d-ba4d868f4785 | 3 | 1 | 3 | 1 |
| 456e25a3-c764-4db6-8882-bb2d910056c8 | 3 | 1 | 3 | 1 |
| 3a35179a-0dc4-4a42-919e-bc162f72f1fe | 3 | 1 | 3 | 1 |
| ad449824-295e-4206-bd1e-bd2b1c40bbea | 3 | 1 | 3 | 1 |
| 3e8a6625-47d0-44d7-b828-bee0f14af8d8 | 3 | 1 | 3 | 1 |
| 24bd32b1-1ebf-47bb-9abd-c04a1d81a19e | 3 | 1 | 3 | 1 |
| a69de8f7-bf01-4007-a224-c1140d50668e | 3 | 1 | 3 | 1 |
| 869a177b-bc20-45d1-9ec6-c43f2d12dae7 | 3 | 1 | 3 | 1 |
| 922e42da-740a-485f-9215-c744fc7121dc | 7 | 1 | 7 | 1 |
| ad2071c7-af42-4015-aefc-c8a7bbcbc39d | 3 | 1 | 3 | 1 |
| b568b735-7e08-4440-850d-c9a0ac38a4e1 | 7 | 1 | 7 | 1 |
| 1964fc65-5b49-471f-bbff-cb55c7e60d89 | 7 | 1 | 7 | 1 |
| 66ab5137-3750-4f9c-a3ac-cd244dc93ed1 | 7 | 1 | 7 | 1 |
| bc51ded6-e47e-48b4-842f-cdb4aca93c7a | 3 | 1 | 3 | 1 |
| 61fa9306-ad9d-444a-8d6b-d05658602bf7 | 7 | 1 | 7 | 1 |
| 7e1c2818-8f6e-4114-9f9a-d17641c10870 | 3 | 1 | 3 | 1 |
| 85b6953e-ec0b-4125-bb4d-d26fa3827130 | 3 | 1 | 3 | 1 |
| 4fae0b9c-5aaf-4019-96ee-d3e74f2d9357 | 3 | 1 | 3 | 1 |
| 0186491f-6a89-4a4a-92ea-d4938125a635 | 3 | 1 | 3 | 1 |
| f502f0f9-97df-4e2a-b49e-d61ec2b37726 | 3 | 1 | 3 | 1 |
| ce25af40-3fd3-40cb-8bbe-d8217b2d39cc | 3 | 1 | 3 | 1 |
| 19363775-ba66-4738-aaf1-d8b96bdac023 | 4 | 1 | 4 | 1 |
| 3bba7a71-51c5-48ec-b7ae-d9ec439fb569 | 5 | 1 | 5 | 1 |
| 3e139bdb-4810-464e-9283-decd32939688 | 11 | 1 | 11 | 1 |
| 684329f0-a72d-48b8-ab03-df71cdde7d06 | 5 | 1 | 5 | 1 |
| a5e30e4d-4ffc-4357-ab62-e0c436a43e68 | 5 | 1 | 5 | 1 |
| a7ce2adb-7fb1-495c-a927-e18e175609f5 | 5 | 1 | 5 | 1 |
| 2f09db7f-65a2-44c7-98bc-e3e3c51efdc8 | 5 | 1 | 5 | 1 |
| 09688298-ea99-4f9c-b64a-e54c53254a63 | 5 | 1 | 5 | 1 |
| 535368eb-c789-426c-bc96-e7f66716e63f | 5 | 1 | 5 | 1 |
| f42fa85c-152d-447a-a2a7-e988a8d598b9 | 5 | 1 | 5 | 1 |
| 776f5e4b-6bed-4468-9b79-ea85f10eb54b | 5 | 1 | 5 | 1 |
| 729dbb82-ed84-42f2-91c2-ec78980aae81 | 5 | 1 | 5 | 1 |
| 0dccacf7-119f-4af6-b64a-edcdb3d55951 | 5 | 1 | 5 | 1 |
| 58bca248-2fa8-49a8-a159-ef1e0b80dbda | 5 | 1 | 5 | 1 |
| bb0d2db0-bfa0-4d17-a635-f056936429a4 | 5 | 1 | 5 | 1 |
| a315ad94-37b6-4ca8-9bcc-f1301f93abbc | 5 | 1 | 5 | 1 |
| 056136b8-e60c-49c7-a0f0-f492ff1d3059 | 6 | 1 | 6 | 1 |
| b37517d9-2e0d-4bde-be9e-f606366688f3 | 7 | 1 | 7 | 1 |
| 2d6b89d0-5e2b-4739-b03e-f970a0fd800b | 7 | 1 | 7 | 1 |
| a66167b8-1403-4af7-9cdf-fb8169093f69 | 7 | 1 | 7 | 1 |
| 5a97fe1a-7691-4584-ad29-fce91fed0c82 | 7 | 1 | 7 | 1 |
| d4da00f5-5f87-4cc3-bf4c-ff47b076dc7f | 6 | 1 | 6 | 1 |
| 7e9f7f21-89a0-474b-9589-fff1d2bdcd32 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| IX_BusinessEntityContact_PersonID | Aug 8 2010 5:23PM | 909 | 909 | 197 | 1 | 12 |
|
909 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.00110011 | 4 | PersonID |
| 0.00110011 | 8 | PersonID, BusinessEntityID |
| 0.00110011 | 12 | PersonID, BusinessEntityID, ContactTypeID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 291 | 0 | 1 | 0 | 1 |
| 305 | 6 | 1 | 6 | 1 |
| 313 | 3 | 1 | 3 | 1 |
| 321 | 3 | 1 | 3 | 1 |
| 329 | 3 | 1 | 3 | 1 |
| 337 | 3 | 1 | 3 | 1 |
| 345 | 3 | 1 | 3 | 1 |
| 353 | 3 | 1 | 3 | 1 |
| 361 | 3 | 1 | 3 | 1 |
| 369 | 3 | 1 | 3 | 1 |
| 377 | 3 | 1 | 3 | 1 |
| 389 | 5 | 1 | 5 | 1 |
| 397 | 3 | 1 | 3 | 1 |
| 409 | 5 | 1 | 5 | 1 |
| 417 | 3 | 1 | 3 | 1 |
| 433 | 7 | 1 | 7 | 1 |
| 441 | 3 | 1 | 3 | 1 |
| 449 | 3 | 1 | 3 | 1 |
| 457 | 3 | 1 | 3 | 1 |
| 465 | 3 | 1 | 3 | 1 |
| 473 | 3 | 1 | 3 | 1 |
| 481 | 3 | 1 | 3 | 1 |
| 489 | 3 | 1 | 3 | 1 |
| 501 | 5 | 1 | 5 | 1 |
| 513 | 5 | 1 | 5 | 1 |
| 521 | 3 | 1 | 3 | 1 |
| 537 | 7 | 1 | 7 | 1 |
| 545 | 3 | 1 | 3 | 1 |
| 553 | 3 | 1 | 3 | 1 |
| 569 | 7 | 1 | 7 | 1 |
| 585 | 7 | 1 | 7 | 1 |
| 597 | 5 | 1 | 5 | 1 |
| 605 | 3 | 1 | 3 | 1 |
| 613 | 3 | 1 | 3 | 1 |
| 625 | 5 | 1 | 5 | 1 |
| 633 | 3 | 1 | 3 | 1 |
| 641 | 3 | 1 | 3 | 1 |
| 649 | 3 | 1 | 3 | 1 |
| 657 | 3 | 1 | 3 | 1 |
| 665 | 3 | 1 | 3 | 1 |
| 677 | 5 | 1 | 5 | 1 |
| 685 | 3 | 1 | 3 | 1 |
| 693 | 3 | 1 | 3 | 1 |
| 701 | 3 | 1 | 3 | 1 |
| 709 | 3 | 1 | 3 | 1 |
| 717 | 3 | 1 | 3 | 1 |
| 725 | 3 | 1 | 3 | 1 |
| 733 | 3 | 1 | 3 | 1 |
| 741 | 3 | 1 | 3 | 1 |
| 749 | 3 | 1 | 3 | 1 |
| 757 | 3 | 1 | 3 | 1 |
| 765 | 3 | 1 | 3 | 1 |
| 773 | 3 | 1 | 3 | 1 |
| 785 | 5 | 1 | 5 | 1 |
| 793 | 3 | 1 | 3 | 1 |
| 801 | 3 | 1 | 3 | 1 |
| 809 | 3 | 1 | 3 | 1 |
| 817 | 3 | 1 | 3 | 1 |
| 829 | 5 | 1 | 5 | 1 |
| 841 | 5 | 1 | 5 | 1 |
| 849 | 3 | 1 | 3 | 1 |
| 857 | 3 | 1 | 3 | 1 |
| 865 | 3 | 1 | 3 | 1 |
| 873 | 3 | 1 | 3 | 1 |
| 881 | 3 | 1 | 3 | 1 |
| 889 | 3 | 1 | 3 | 1 |
| 901 | 5 | 1 | 5 | 1 |
| 909 | 3 | 1 | 3 | 1 |
| 917 | 3 | 1 | 3 | 1 |
| 929 | 5 | 1 | 5 | 1 |
| 937 | 3 | 1 | 3 | 1 |
| 949 | 5 | 1 | 5 | 1 |
| 957 | 3 | 1 | 3 | 1 |
| 973 | 7 | 1 | 7 | 1 |
| 981 | 3 | 1 | 3 | 1 |
| 989 | 3 | 1 | 3 | 1 |
| 1001 | 5 | 1 | 5 | 1 |
| 1009 | 3 | 1 | 3 | 1 |
| 1017 | 3 | 1 | 3 | 1 |
| 1025 | 3 | 1 | 3 | 1 |
| 1033 | 3 | 1 | 3 | 1 |
| 1041 | 3 | 1 | 3 | 1 |
| 1049 | 3 | 1 | 3 | 1 |
| 1061 | 5 | 1 | 5 | 1 |
| 1073 | 5 | 1 | 5 | 1 |
| 1081 | 3 | 1 | 3 | 1 |
| 1091 | 4 | 1 | 4 | 1 |
| 1099 | 3 | 1 | 3 | 1 |
| 1107 | 3 | 1 | 3 | 1 |
| 1115 | 3 | 1 | 3 | 1 |
| 1123 | 3 | 1 | 3 | 1 |
| 1131 | 3 | 1 | 3 | 1 |
| 1139 | 3 | 1 | 3 | 1 |
| 1147 | 3 | 1 | 3 | 1 |
| 1155 | 3 | 1 | 3 | 1 |
| 1163 | 3 | 1 | 3 | 1 |
| 1171 | 3 | 1 | 3 | 1 |
| 1179 | 3 | 1 | 3 | 1 |
| 1187 | 3 | 1 | 3 | 1 |
| 1195 | 3 | 1 | 3 | 1 |
| 1203 | 3 | 1 | 3 | 1 |
| 1211 | 3 | 1 | 3 | 1 |
| 1219 | 3 | 1 | 3 | 1 |
| 1227 | 3 | 1 | 3 | 1 |
| 1243 | 7 | 1 | 7 | 1 |
| 1251 | 3 | 1 | 3 | 1 |
| 1259 | 3 | 1 | 3 | 1 |
| 1267 | 3 | 1 | 3 | 1 |
| 1275 | 3 | 1 | 3 | 1 |
| 1283 | 3 | 1 | 3 | 1 |
| 1291 | 3 | 1 | 3 | 1 |
| 1299 | 3 | 1 | 3 | 1 |
| 1307 | 3 | 1 | 3 | 1 |
| 1315 | 3 | 1 | 3 | 1 |
| 1323 | 3 | 1 | 3 | 1 |
| 1331 | 3 | 1 | 3 | 1 |
| 1339 | 3 | 1 | 3 | 1 |
| 1347 | 3 | 1 | 3 | 1 |
| 1355 | 3 | 1 | 3 | 1 |
| 1363 | 3 | 1 | 3 | 1 |
| 1371 | 3 | 1 | 3 | 1 |
| 1379 | 3 | 1 | 3 | 1 |
| 1387 | 3 | 1 | 3 | 1 |
| 1395 | 3 | 1 | 3 | 1 |
| 1403 | 3 | 1 | 3 | 1 |
| 1411 | 3 | 1 | 3 | 1 |
| 1419 | 3 | 1 | 3 | 1 |
| 1427 | 3 | 1 | 3 | 1 |
| 1435 | 3 | 1 | 3 | 1 |
| 1443 | 3 | 1 | 3 | 1 |
| 1451 | 3 | 1 | 3 | 1 |
| 1459 | 3 | 1 | 3 | 1 |
| 1467 | 3 | 1 | 3 | 1 |
| 1475 | 3 | 1 | 3 | 1 |
| 1483 | 3 | 1 | 3 | 1 |
| 1491 | 3 | 1 | 3 | 1 |
| 1499 | 3 | 1 | 3 | 1 |
| 1507 | 3 | 1 | 3 | 1 |
| 1515 | 3 | 1 | 3 | 1 |
| 1523 | 3 | 1 | 3 | 1 |
| 1531 | 3 | 1 | 3 | 1 |
| 1539 | 3 | 1 | 3 | 1 |
| 1547 | 3 | 1 | 3 | 1 |
| 1555 | 3 | 1 | 3 | 1 |
| 1563 | 3 | 1 | 3 | 1 |
| 1571 | 3 | 1 | 3 | 1 |
| 1579 | 3 | 1 | 3 | 1 |
| 1587 | 3 | 1 | 3 | 1 |
| 1595 | 3 | 1 | 3 | 1 |
| 1603 | 3 | 1 | 3 | 1 |
| 1611 | 3 | 1 | 3 | 1 |
| 1619 | 3 | 1 | 3 | 1 |
| 1627 | 3 | 1 | 3 | 1 |
| 1635 | 3 | 1 | 3 | 1 |
| 1643 | 3 | 1 | 3 | 1 |
| 1651 | 3 | 1 | 3 | 1 |
| 1659 | 3 | 1 | 3 | 1 |
| 1667 | 3 | 1 | 3 | 1 |
| 1675 | 3 | 1 | 3 | 1 |
| 1683 | 3 | 1 | 3 | 1 |
| 1691 | 3 | 1 | 3 | 1 |
| 1785 | 3 | 1 | 3 | 1 |
| 1789 | 3 | 1 | 3 | 1 |
| 1793 | 3 | 1 | 3 | 1 |
| 1799 | 3 | 1 | 3 | 1 |
| 1807 | 3 | 1 | 3 | 1 |
| 1815 | 3 | 1 | 3 | 1 |
| 1823 | 3 | 1 | 3 | 1 |
| 1831 | 3 | 1 | 3 | 1 |
| 1839 | 3 | 1 | 3 | 1 |
| 1847 | 3 | 1 | 3 | 1 |
| 1855 | 3 | 1 | 3 | 1 |
| 1863 | 3 | 1 | 3 | 1 |
| 1871 | 3 | 1 | 3 | 1 |
| 1879 | 3 | 1 | 3 | 1 |
| 1887 | 3 | 1 | 3 | 1 |
| 1897 | 4 | 1 | 4 | 1 |
| 1909 | 5 | 1 | 5 | 1 |
| 1921 | 5 | 1 | 5 | 1 |
| 1933 | 5 | 1 | 5 | 1 |
| 1945 | 5 | 1 | 5 | 1 |
| 1957 | 5 | 1 | 5 | 1 |
| 1969 | 5 | 1 | 5 | 1 |
| 1981 | 5 | 1 | 5 | 1 |
| 1993 | 5 | 1 | 5 | 1 |
| 2006 | 11 | 1 | 11 | 1 |
| 2012 | 5 | 1 | 5 | 1 |
| 2018 | 5 | 1 | 5 | 1 |
| 2024 | 5 | 1 | 5 | 1 |
| 2030 | 5 | 1 | 5 | 1 |
| 2036 | 5 | 1 | 5 | 1 |
| 2042 | 5 | 1 | 5 | 1 |
| 2049 | 6 | 1 | 6 | 1 |
| 2074 | 23 | 1 | 23 | 1 |
| 2082 | 7 | 1 | 7 | 1 |
| 2089 | 6 | 1 | 6 | 1 |
| 2090 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| IX_BusinessEntityContact_ContactTypeID | Aug 8 2010 5:23PM | 909 | 909 | 7 | 0 | 12 |
|
909 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.1428571 | 4 | ContactTypeID |
| 0.00110011 | 8 | ContactTypeID, BusinessEntityID |
| 0.00110011 | 12 | ContactTypeID, BusinessEntityID, PersonID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 2 | 0 | 18 | 0 | 1 |
| 11 | 0 | 266 | 0 | 1 |
| 14 | 0 | 242 | 0 | 1 |
| 15 | 0 | 245 | 0 | 1 |
| 17 | 0 | 54 | 0 | 1 |
| 18 | 0 | 44 | 0 | 1 |
| 19 | 0 | 40 | 0 | 1 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Person].[BusinessEntityContact]( [BusinessEntityID] [int] NOT NULL, [PersonID] [int] NOT NULL, [ContactTypeID] [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'BusinessEntityContact', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to Person.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityContact', @level2type=N'COLUMN',@level2name=N'PersonID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to ContactType.ContactTypeID.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityContact', @level2type=N'COLUMN',@level2name=N'ContactTypeID' 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'BusinessEntityContact', @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'BusinessEntityContact', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference table mapping stores, vendors, and employees to people' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntityContact' |