Table: Customer Table: Customer| Property | Value |
|---|---|
| Name | Customer |
| ID | 709577566 |
| Owner | dbo |
| Schema | Sales |
| Filegroup | PRIMARY |
| Data Size (KB) | 968 KB |
| Index Size (KB) | 1216 KB |
| Rows | 19820 |
| Unused (KB) | 408 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:41 PM |
| Create Date | 8/8/2010 5:21:47 PM |
| Name | Value |
|---|---|
| MS_Description | Current customer information. Also see the Person and Store tables. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | CustomerID | int |
|
|
|
| 2 | PersonID | int |
|
|
|
| 3 | StoreID | int |
|
|
|
| 4 | TerritoryID | int |
|
|
|
| 5 | AccountNumber | varchar(10) |
|
|
|
| 6 | rowguid | uniqueidentifier |
|
|
|
| 7 | ModifiedDate | datetime |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| CustomerID | 1 | 1 | 30118 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_Customer_CustomerID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| CustomerID |
| Name | Referenced Object | Update Action | Delete Action |
|---|---|---|---|
| FK_Customer_Person_PersonID | Person.Person | No action | No action |
| FK_Customer_Store_StoreID | Sales.Store | No action | No action |
| FK_Customer_SalesTerritory_TerritoryID | Sales.SalesTerritory | No action | No action |
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_Customer_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_Customer_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_Customer_CustomerID | CLUSTERED |
|
|
|
|
|
| AK_Customer_rowguid | NONCLUSTERED |
|
|
|
|
|
| AK_Customer_AccountNumber | NONCLUSTERED |
|
|
|
|
|
| IX_Customer_TerritoryID | NONCLUSTERED |
|
|
|
|
|
| Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object |
|---|---|---|---|---|---|---|---|---|
| FK_SalesOrderHeader_Customer_CustomerID | 1 |
|
|
|
No action | No action |
|
Sales.SalesOrderHeader |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_Customer_CustomerID | Aug 8 2010 5:22PM | 19820 | 19820 | 6 | 1 | 4 |
|
19820 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.045409E-05 | 4 | CustomerID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1 | 0 | 1 | 0 | 1 |
| 680 | 678 | 1 | 678 | 1 |
| 11106 | 127 | 1 | 127 | 1 |
| 30114 | 19007 | 1 | 19007 | 1 |
| 30117 | 2 | 1 | 2 | 1 |
| 30118 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_Customer_rowguid | Aug 8 2010 5:23PM | 19820 | 19820 | 120 | 1 | 20 |
|
19820 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.045409E-05 | 16 | rowguid |
| 5.045409E-05 | 20 | rowguid, CustomerID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 78ae5eaf-fc61-4c92-8fcf-0001086810d2 | 0 | 1 | 0 | 1 |
| bd4ce520-0448-4806-be08-0201fa361b0d | 156 | 1 | 156 | 1 |
| 50ba7304-37a3-4fb8-91d9-02a06c7b569e | 41 | 1 | 41 | 1 |
| 7b4d5173-4258-40c9-8848-034ef1cd56a5 | 63 | 1 | 63 | 1 |
| 27dd190a-93ac-492c-bb64-04f52a87cd30 | 127 | 1 | 127 | 1 |
| ab207546-4bb6-4dc7-baa0-07c1c9e17944 | 191 | 1 | 191 | 1 |
| 84d4b69c-8ac7-493d-bbee-0ad014e78f47 | 223 | 1 | 223 | 1 |
| 2aa331a0-6448-4ea9-9a92-0ebf254bdcd3 | 255 | 1 | 255 | 1 |
| 016d0f41-c9a0-4a78-b054-0ff13e54ddac | 95 | 1 | 95 | 1 |
| 683f87ff-a0d2-4a7d-a4c7-1892e836adbb | 671 | 1 | 671 | 1 |
| f7b2358e-a22c-4c6e-9676-1b49bc79505d | 191 | 1 | 191 | 1 |
| 312de342-813f-4c38-8875-1ce93341dc80 | 127 | 1 | 127 | 1 |
| d241d8f1-5a7a-41b3-8723-1e2b1a9fdbf6 | 127 | 1 | 127 | 1 |
| 741c8f3f-57d4-42df-a36a-2011e4f56d69 | 159 | 1 | 159 | 1 |
| 49f87bb5-913f-4ee1-8c29-243c3e6fd9b7 | 319 | 1 | 319 | 1 |
| 0e55c62a-aff0-4291-b6df-25459a18fcb5 | 63 | 1 | 63 | 1 |
| 02c8ef31-670e-4945-94fb-2a8924ad2e58 | 415 | 1 | 415 | 1 |
| 70600439-cd7a-413b-9c9d-2bea3f230a39 | 95 | 1 | 95 | 1 |
| e93286f4-bcd2-4a43-af06-315cbd8bbe53 | 415 | 1 | 415 | 1 |
| ae422ea0-d7c2-4804-8e11-3354822a72ae | 159 | 1 | 159 | 1 |
| 7abc5838-9f80-43f3-855b-343abcf98719 | 63 | 1 | 63 | 1 |
| 31e07383-a88d-4fd4-a6b2-35642e47ebd6 | 95 | 1 | 95 | 1 |
| a140107b-57b4-4a73-8665-3614650253fa | 63 | 1 | 63 | 1 |
| 15280fc3-e9e2-429e-9793-3772527e7e82 | 95 | 1 | 95 | 1 |
| a6a48796-ffc9-45a9-913b-3875d0df4d53 | 95 | 1 | 95 | 1 |
| 7b89281c-d746-44b5-a293-3993f7f290c9 | 95 | 1 | 95 | 1 |
| 56b3b88d-a4bf-48e0-bef3-3df47f22aa29 | 351 | 1 | 351 | 1 |
| 3ac64ddb-8c00-4507-ad85-3fd0dc916556 | 159 | 1 | 159 | 1 |
| 50f22dd0-6e0b-49e1-b9c0-40c71f35c468 | 63 | 1 | 63 | 1 |
| f0d8ae35-f3bc-4854-af66-44bb37d58150 | 319 | 1 | 319 | 1 |
| 6ce61916-9028-4f7d-8c85-4592fee2d2f1 | 63 | 1 | 63 | 1 |
| f7df1bd4-2612-477d-86c5-468aaba715a8 | 63 | 1 | 63 | 1 |
| 6cee5194-73ec-4b1b-9610-4816363e6d0d | 127 | 1 | 127 | 1 |
| 9a729c90-8145-46e0-a3d7-496b6399e0cd | 95 | 1 | 95 | 1 |
| 50d0710e-39cd-4373-9346-4a6974e8b0c5 | 63 | 1 | 63 | 1 |
| 6d6d57ed-29b0-4428-9456-4c66d099607f | 159 | 1 | 159 | 1 |
| d453a811-136e-4a95-99bd-4f3dd15513aa | 191 | 1 | 191 | 1 |
| c8fa1f71-cb9d-4249-92d5-501a35d41b32 | 63 | 1 | 63 | 1 |
| f99b5561-0991-45da-9e14-510ac7d5e122 | 63 | 1 | 63 | 1 |
| 147692e6-80fe-492f-97f6-51d9c5aa0c36 | 63 | 1 | 63 | 1 |
| a06b58a2-d3f1-43ea-86b3-53afdab6524c | 127 | 1 | 127 | 1 |
| ce2ae9ff-7a69-4ee8-b0ee-5697dbcf943e | 255 | 1 | 255 | 1 |
| 266ffa62-b10a-475d-a3a7-5895e820acef | 191 | 1 | 191 | 1 |
| c2f6d8b6-5e70-400d-b313-596170b2939b | 63 | 1 | 63 | 1 |
| c59ff5e7-37fb-4651-94b6-5b45fa426a71 | 127 | 1 | 127 | 1 |
| 506dd7e7-e6d0-49e7-addc-5cd6c811dd35 | 127 | 1 | 127 | 1 |
| 1ee36a6d-f889-4e61-b058-5eb1f500e928 | 127 | 1 | 127 | 1 |
| e71f08b0-d833-4a3c-a9cf-610fefa9e6cb | 191 | 1 | 191 | 1 |
| 4237bdd6-cef5-4ba2-88f7-620117431d25 | 63 | 1 | 63 | 1 |
| e092ffa5-31e5-471e-b2c5-653730617416 | 255 | 1 | 255 | 1 |
| 0df0253b-3414-4bb9-9839-65e062cd40b0 | 63 | 1 | 63 | 1 |
| 2b851d85-7adb-480b-880c-6a8ebcb0e91a | 319 | 1 | 319 | 1 |
| 52a46b06-0c46-4f8a-beaf-6b6b9fa8121b | 63 | 1 | 63 | 1 |
| ef980b59-0054-48c9-b657-6d660bf362fc | 127 | 1 | 127 | 1 |
| b06d8641-1d4d-4f09-aaca-70af715b153a | 255 | 1 | 255 | 1 |
| cd808342-4f47-4c9a-8c7c-71bb3201d79e | 63 | 1 | 63 | 1 |
| 41f508e3-9ab0-4a9b-90aa-72728858c164 | 63 | 1 | 63 | 1 |
| d358a293-3a8e-4b53-8b77-772721eacddb | 383 | 1 | 383 | 1 |
| a0efcc16-a0bc-4648-8e48-77fe3004c727 | 63 | 1 | 63 | 1 |
| 4bf28383-dd82-46f0-b06f-79649380db40 | 127 | 1 | 127 | 1 |
| ff341e9d-6bdb-49fb-8332-7b1e22609926 | 127 | 1 | 127 | 1 |
| 825a2114-c6fb-45d3-a568-7c12099b81a2 | 63 | 1 | 63 | 1 |
| 079087ac-5199-4ffc-82f9-7dc0b591d99c | 127 | 1 | 127 | 1 |
| 35d4b6f9-526e-4310-88cb-7f3b819cec83 | 127 | 1 | 127 | 1 |
| 2b46fd3a-5be3-4fc4-8263-80298c6922b3 | 63 | 1 | 63 | 1 |
| abef8d2d-a1ab-4598-8012-81a744c60820 | 127 | 1 | 127 | 1 |
| 12d13b77-f469-4e85-bcc0-8291e783c5b7 | 63 | 1 | 63 | 1 |
| effbf3a0-4075-4e4e-abc1-8403fc6f5b01 | 127 | 1 | 127 | 1 |
| 5e38bbf9-39a9-45a5-8494-84cd21ecae93 | 63 | 1 | 63 | 1 |
| 2e2c4663-af98-4ecb-ba84-85ba82e69275 | 63 | 1 | 63 | 1 |
| e90cb862-c176-4a7c-a44a-87519d306d26 | 127 | 1 | 127 | 1 |
| affa342a-e830-4d92-85a1-880705bddf52 | 63 | 1 | 63 | 1 |
| f47cdf40-0b64-4ee7-9bd4-89903adba34b | 127 | 1 | 127 | 1 |
| e9ff5cd0-4686-47b8-9d49-8b209a0e6c5e | 127 | 1 | 127 | 1 |
| a5bc8652-668c-4b84-9525-8bd707c4f588 | 63 | 1 | 63 | 1 |
| 97f4400f-53ad-41e1-a6eb-8f9bd364b002 | 319 | 1 | 319 | 1 |
| 1bab5cc7-25c4-494f-8e96-924cb341dda5 | 191 | 1 | 191 | 1 |
| e3f8a169-7bbe-4c84-9285-93b321321f4e | 127 | 1 | 127 | 1 |
| b17c77ed-825c-4ae9-bb22-960f5126b19d | 191 | 1 | 191 | 1 |
| 84b18a06-9156-4417-bf22-96bb20466535 | 63 | 1 | 63 | 1 |
| 57687bca-019a-458a-9da4-989a9ee9bb04 | 127 | 1 | 127 | 1 |
| b72a5f9c-2c96-4a87-8b83-99a9e982e16a | 95 | 1 | 95 | 1 |
| 521df6e3-af53-4ccc-adf3-9d59c7951b8d | 287 | 1 | 287 | 1 |
| 7d8d8366-982d-4399-b43a-a01aa10a49a8 | 191 | 1 | 191 | 1 |
| feeb0dd1-f2b3-47a2-b192-a13b26b0e5db | 95 | 1 | 95 | 1 |
| c1cd62a3-6bae-4232-bd10-a28b47c815e8 | 95 | 1 | 95 | 1 |
| 2ca8828f-2b56-4e16-a786-a4fa2d8b4027 | 191 | 1 | 191 | 1 |
| 5e9734da-a57e-41dd-bb46-a8dc77f6f9c4 | 287 | 1 | 287 | 1 |
| c25b31d9-dc1c-4ba6-8373-aa509ce90804 | 95 | 1 | 95 | 1 |
| fe081a9d-aa9e-4ff1-b244-ac6b597e3f7b | 191 | 1 | 191 | 1 |
| 810254bd-7a7e-45ab-9db5-aeade2d88615 | 191 | 1 | 191 | 1 |
| 4e3e50da-64ca-48be-915f-b145ab8e9fef | 191 | 1 | 191 | 1 |
| cc8ee816-49fd-417e-b438-b37f6ba39030 | 191 | 1 | 191 | 1 |
| dd99608d-abb8-4345-ad44-b4819a8a9502 | 95 | 1 | 95 | 1 |
| 15327bf1-39a2-4e77-97c6-b8889a2e48bc | 287 | 1 | 287 | 1 |
| 5dd7d241-74e6-4de1-aa70-bb0390efadbb | 223 | 1 | 223 | 1 |
| 6aed0286-9f12-40ae-a884-be5e54967648 | 255 | 1 | 255 | 1 |
| 9fc55dfc-3dfe-47b7-be42-bfd873d61451 | 127 | 1 | 127 | 1 |
| 37276edd-b122-435b-bcab-c38f17bc0e20 | 255 | 1 | 255 | 1 |
| 3c9496ca-ba0d-4dfe-bc94-c53c4ea2b48b | 127 | 1 | 127 | 1 |
| d924f545-a243-407b-824f-caacd680afdb | 383 | 1 | 383 | 1 |
| 08a59db8-dc8b-46d5-ae2d-cf97a5ee5c38 | 383 | 1 | 383 | 1 |
| 086c3399-b512-47c3-9db1-d1032d0248b3 | 127 | 1 | 127 | 1 |
| 8e7eb8a7-89a9-4267-bdcd-d2b7f4788bd2 | 127 | 1 | 127 | 1 |
| db9ff0a4-5b14-422f-9dab-d4c26584043a | 127 | 1 | 127 | 1 |
| 55b6ca6c-ed56-4be5-8326-d817680892b1 | 255 | 1 | 255 | 1 |
| fd00c350-df47-4895-8679-dba40678ea5c | 255 | 1 | 255 | 1 |
| ca2562e1-c933-4332-8b2a-dd30de8f9381 | 127 | 1 | 127 | 1 |
| 79adf45e-23d3-4c1c-8599-deeb97742714 | 127 | 1 | 127 | 1 |
| 1e151b4c-401c-4166-8451-e1e668068d5b | 255 | 1 | 255 | 1 |
| ae9b5831-5c2c-47a9-8fc3-e3b9bc3278aa | 127 | 1 | 127 | 1 |
| 1f519b4d-f47e-4b60-b33b-e6836fe0bfec | 255 | 1 | 255 | 1 |
| abd5d258-076c-4c35-bfe5-e8530cefac9e | 127 | 1 | 127 | 1 |
| 7d0cc763-d6a7-456f-b672-ed0e47441401 | 383 | 1 | 383 | 1 |
| 781db145-8848-4444-aff2-f25c19128db7 | 383 | 1 | 383 | 1 |
| 34c0039a-98bc-4e08-933d-f71ce9e98134 | 383 | 1 | 383 | 1 |
| 4f898384-e8a0-47ac-b8db-f8f187b86b13 | 127 | 1 | 127 | 1 |
| f7bcd0d0-f7d5-4c6d-932b-fe06d6eed74f | 383 | 1 | 383 | 1 |
| 022e88d9-c326-4efa-8d76-ffe319ac7d80 | 127 | 1 | 127 | 1 |
| 42ba6902-d6e3-41ef-a714-fffcf701ccef | 3 | 1 | 3 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_Customer_AccountNumber | Aug 8 2010 5:23PM | 19820 | 19820 | 152 | 1 | 14 |
|
19820 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.045409E-05 | 10 | AccountNumber |
| 5.045409E-05 | 14 | AccountNumber, CustomerID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| AW00000001 | 0 | 1 | 0 | 1 |
| AW00000096 | 94 | 1 | 94 | 1 |
| AW00000158 | 61 | 1 | 61 | 1 |
| AW00000200 | 41 | 1 | 41 | 1 |
| AW00000264 | 63 | 1 | 63 | 1 |
| AW00000392 | 127 | 1 | 127 | 1 |
| AW00000456 | 63 | 1 | 63 | 1 |
| AW00000584 | 127 | 1 | 127 | 1 |
| AW00000680 | 95 | 1 | 95 | 1 |
| AW00011106 | 127 | 1 | 127 | 1 |
| AW00011362 | 255 | 1 | 255 | 1 |
| AW00011458 | 95 | 1 | 95 | 1 |
| AW00011522 | 63 | 1 | 63 | 1 |
| AW00011586 | 63 | 1 | 63 | 1 |
| AW00011650 | 63 | 1 | 63 | 1 |
| AW00011746 | 95 | 1 | 95 | 1 |
| AW00011810 | 63 | 1 | 63 | 1 |
| AW00011938 | 127 | 1 | 127 | 1 |
| AW00012034 | 95 | 1 | 95 | 1 |
| AW00012130 | 95 | 1 | 95 | 1 |
| AW00012194 | 63 | 1 | 63 | 1 |
| AW00012322 | 127 | 1 | 127 | 1 |
| AW00012578 | 255 | 1 | 255 | 1 |
| AW00012642 | 63 | 1 | 63 | 1 |
| AW00012738 | 95 | 1 | 95 | 1 |
| AW00012866 | 127 | 1 | 127 | 1 |
| AW00012962 | 95 | 1 | 95 | 1 |
| AW00013058 | 95 | 1 | 95 | 1 |
| AW00013122 | 63 | 1 | 63 | 1 |
| AW00013314 | 191 | 1 | 191 | 1 |
| AW00013442 | 127 | 1 | 127 | 1 |
| AW00013634 | 191 | 1 | 191 | 1 |
| AW00013698 | 63 | 1 | 63 | 1 |
| AW00013826 | 127 | 1 | 127 | 1 |
| AW00013922 | 95 | 1 | 95 | 1 |
| AW00014050 | 127 | 1 | 127 | 1 |
| AW00014114 | 63 | 1 | 63 | 1 |
| AW00014210 | 95 | 1 | 95 | 1 |
| AW00014274 | 63 | 1 | 63 | 1 |
| AW00014370 | 95 | 1 | 95 | 1 |
| AW00014434 | 63 | 1 | 63 | 1 |
| AW00014722 | 287 | 1 | 287 | 1 |
| AW00014786 | 63 | 1 | 63 | 1 |
| AW00014882 | 95 | 1 | 95 | 1 |
| AW00014946 | 63 | 1 | 63 | 1 |
| AW00015074 | 127 | 1 | 127 | 1 |
| AW00015138 | 63 | 1 | 63 | 1 |
| AW00015234 | 95 | 1 | 95 | 1 |
| AW00015298 | 63 | 1 | 63 | 1 |
| AW00015490 | 191 | 1 | 191 | 1 |
| AW00015618 | 127 | 1 | 127 | 1 |
| AW00015682 | 63 | 1 | 63 | 1 |
| AW00015746 | 63 | 1 | 63 | 1 |
| AW00015874 | 127 | 1 | 127 | 1 |
| AW00015970 | 95 | 1 | 95 | 1 |
| AW00016034 | 63 | 1 | 63 | 1 |
| AW00016130 | 95 | 1 | 95 | 1 |
| AW00016194 | 63 | 1 | 63 | 1 |
| AW00016386 | 191 | 1 | 191 | 1 |
| AW00016514 | 127 | 1 | 127 | 1 |
| AW00016578 | 63 | 1 | 63 | 1 |
| AW00016706 | 127 | 1 | 127 | 1 |
| AW00016834 | 127 | 1 | 127 | 1 |
| AW00016898 | 63 | 1 | 63 | 1 |
| AW00016962 | 63 | 1 | 63 | 1 |
| AW00017026 | 63 | 1 | 63 | 1 |
| AW00017154 | 127 | 1 | 127 | 1 |
| AW00017218 | 63 | 1 | 63 | 1 |
| AW00017474 | 255 | 1 | 255 | 1 |
| AW00017602 | 127 | 1 | 127 | 1 |
| AW00017666 | 63 | 1 | 63 | 1 |
| AW00017794 | 127 | 1 | 127 | 1 |
| AW00017858 | 63 | 1 | 63 | 1 |
| AW00017986 | 127 | 1 | 127 | 1 |
| AW00018050 | 63 | 1 | 63 | 1 |
| AW00018114 | 63 | 1 | 63 | 1 |
| AW00018178 | 63 | 1 | 63 | 1 |
| AW00018306 | 127 | 1 | 127 | 1 |
| AW00018370 | 63 | 1 | 63 | 1 |
| AW00018498 | 127 | 1 | 127 | 1 |
| AW00018562 | 63 | 1 | 63 | 1 |
| AW00018690 | 127 | 1 | 127 | 1 |
| AW00018818 | 127 | 1 | 127 | 1 |
| AW00018946 | 127 | 1 | 127 | 1 |
| AW00019010 | 63 | 1 | 63 | 1 |
| AW00019074 | 63 | 1 | 63 | 1 |
| AW00019202 | 127 | 1 | 127 | 1 |
| AW00019458 | 255 | 1 | 255 | 1 |
| AW00019522 | 63 | 1 | 63 | 1 |
| AW00019778 | 255 | 1 | 255 | 1 |
| AW00019842 | 63 | 1 | 63 | 1 |
| AW00019970 | 127 | 1 | 127 | 1 |
| AW00020098 | 127 | 1 | 127 | 1 |
| AW00020162 | 63 | 1 | 63 | 1 |
| AW00020290 | 127 | 1 | 127 | 1 |
| AW00020354 | 63 | 1 | 63 | 1 |
| AW00020482 | 127 | 1 | 127 | 1 |
| AW00020610 | 127 | 1 | 127 | 1 |
| AW00020738 | 127 | 1 | 127 | 1 |
| AW00020802 | 63 | 1 | 63 | 1 |
| AW00020930 | 127 | 1 | 127 | 1 |
| AW00020994 | 63 | 1 | 63 | 1 |
| AW00021058 | 63 | 1 | 63 | 1 |
| AW00021122 | 63 | 1 | 63 | 1 |
| AW00021186 | 63 | 1 | 63 | 1 |
| AW00021314 | 127 | 1 | 127 | 1 |
| AW00021442 | 127 | 1 | 127 | 1 |
| AW00021506 | 63 | 1 | 63 | 1 |
| AW00021570 | 63 | 1 | 63 | 1 |
| AW00021634 | 63 | 1 | 63 | 1 |
| AW00021762 | 127 | 1 | 127 | 1 |
| AW00021826 | 63 | 1 | 63 | 1 |
| AW00021954 | 127 | 1 | 127 | 1 |
| AW00022018 | 63 | 1 | 63 | 1 |
| AW00022146 | 127 | 1 | 127 | 1 |
| AW00022914 | 767 | 1 | 767 | 1 |
| AW00023010 | 95 | 1 | 95 | 1 |
| AW00023202 | 191 | 1 | 191 | 1 |
| AW00023298 | 95 | 1 | 95 | 1 |
| AW00023970 | 671 | 1 | 671 | 1 |
| AW00024066 | 95 | 1 | 95 | 1 |
| AW00024738 | 671 | 1 | 671 | 1 |
| AW00024994 | 255 | 1 | 255 | 1 |
| AW00025122 | 127 | 1 | 127 | 1 |
| AW00025378 | 255 | 1 | 255 | 1 |
| AW00025506 | 127 | 1 | 127 | 1 |
| AW00025890 | 383 | 1 | 383 | 1 |
| AW00026018 | 127 | 1 | 127 | 1 |
| AW00026274 | 255 | 1 | 255 | 1 |
| AW00026402 | 127 | 1 | 127 | 1 |
| AW00026786 | 383 | 1 | 383 | 1 |
| AW00026914 | 127 | 1 | 127 | 1 |
| AW00027042 | 127 | 1 | 127 | 1 |
| AW00027298 | 255 | 1 | 255 | 1 |
| AW00027426 | 127 | 1 | 127 | 1 |
| AW00027682 | 255 | 1 | 255 | 1 |
| AW00027810 | 127 | 1 | 127 | 1 |
| AW00027938 | 127 | 1 | 127 | 1 |
| AW00028066 | 127 | 1 | 127 | 1 |
| AW00028194 | 127 | 1 | 127 | 1 |
| AW00028322 | 127 | 1 | 127 | 1 |
| AW00028578 | 255 | 1 | 255 | 1 |
| AW00028706 | 127 | 1 | 127 | 1 |
| AW00028962 | 255 | 1 | 255 | 1 |
| AW00029090 | 127 | 1 | 127 | 1 |
| AW00029218 | 127 | 1 | 127 | 1 |
| AW00029474 | 255 | 1 | 255 | 1 |
| AW00029602 | 127 | 1 | 127 | 1 |
| AW00029986 | 383 | 1 | 383 | 1 |
| AW00030114 | 127 | 1 | 127 | 1 |
| AW00030117 | 2 | 1 | 2 | 1 |
| AW00030118 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000005_2A4B4B5E | Aug 8 2010 5:23PM | 19820 | 19820 | 152 | 1 | 10 |
|
19820 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.045409E-05 | 10 | AccountNumber |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| AW00000001 | 0 | 1 | 0 | 1 |
| AW00000096 | 94 | 1 | 94 | 1 |
| AW00000158 | 61 | 1 | 61 | 1 |
| AW00000200 | 41 | 1 | 41 | 1 |
| AW00000264 | 63 | 1 | 63 | 1 |
| AW00000392 | 127 | 1 | 127 | 1 |
| AW00000456 | 63 | 1 | 63 | 1 |
| AW00000584 | 127 | 1 | 127 | 1 |
| AW00000680 | 95 | 1 | 95 | 1 |
| AW00011106 | 127 | 1 | 127 | 1 |
| AW00011362 | 255 | 1 | 255 | 1 |
| AW00011458 | 95 | 1 | 95 | 1 |
| AW00011522 | 63 | 1 | 63 | 1 |
| AW00011586 | 63 | 1 | 63 | 1 |
| AW00011650 | 63 | 1 | 63 | 1 |
| AW00011746 | 95 | 1 | 95 | 1 |
| AW00011810 | 63 | 1 | 63 | 1 |
| AW00011938 | 127 | 1 | 127 | 1 |
| AW00012034 | 95 | 1 | 95 | 1 |
| AW00012130 | 95 | 1 | 95 | 1 |
| AW00012194 | 63 | 1 | 63 | 1 |
| AW00012322 | 127 | 1 | 127 | 1 |
| AW00012578 | 255 | 1 | 255 | 1 |
| AW00012642 | 63 | 1 | 63 | 1 |
| AW00012738 | 95 | 1 | 95 | 1 |
| AW00012866 | 127 | 1 | 127 | 1 |
| AW00012962 | 95 | 1 | 95 | 1 |
| AW00013058 | 95 | 1 | 95 | 1 |
| AW00013122 | 63 | 1 | 63 | 1 |
| AW00013314 | 191 | 1 | 191 | 1 |
| AW00013442 | 127 | 1 | 127 | 1 |
| AW00013634 | 191 | 1 | 191 | 1 |
| AW00013698 | 63 | 1 | 63 | 1 |
| AW00013826 | 127 | 1 | 127 | 1 |
| AW00013922 | 95 | 1 | 95 | 1 |
| AW00014050 | 127 | 1 | 127 | 1 |
| AW00014114 | 63 | 1 | 63 | 1 |
| AW00014210 | 95 | 1 | 95 | 1 |
| AW00014274 | 63 | 1 | 63 | 1 |
| AW00014370 | 95 | 1 | 95 | 1 |
| AW00014434 | 63 | 1 | 63 | 1 |
| AW00014722 | 287 | 1 | 287 | 1 |
| AW00014786 | 63 | 1 | 63 | 1 |
| AW00014882 | 95 | 1 | 95 | 1 |
| AW00014946 | 63 | 1 | 63 | 1 |
| AW00015074 | 127 | 1 | 127 | 1 |
| AW00015138 | 63 | 1 | 63 | 1 |
| AW00015234 | 95 | 1 | 95 | 1 |
| AW00015298 | 63 | 1 | 63 | 1 |
| AW00015490 | 191 | 1 | 191 | 1 |
| AW00015618 | 127 | 1 | 127 | 1 |
| AW00015682 | 63 | 1 | 63 | 1 |
| AW00015746 | 63 | 1 | 63 | 1 |
| AW00015874 | 127 | 1 | 127 | 1 |
| AW00015970 | 95 | 1 | 95 | 1 |
| AW00016034 | 63 | 1 | 63 | 1 |
| AW00016130 | 95 | 1 | 95 | 1 |
| AW00016194 | 63 | 1 | 63 | 1 |
| AW00016386 | 191 | 1 | 191 | 1 |
| AW00016514 | 127 | 1 | 127 | 1 |
| AW00016578 | 63 | 1 | 63 | 1 |
| AW00016706 | 127 | 1 | 127 | 1 |
| AW00016834 | 127 | 1 | 127 | 1 |
| AW00016898 | 63 | 1 | 63 | 1 |
| AW00016962 | 63 | 1 | 63 | 1 |
| AW00017026 | 63 | 1 | 63 | 1 |
| AW00017154 | 127 | 1 | 127 | 1 |
| AW00017218 | 63 | 1 | 63 | 1 |
| AW00017474 | 255 | 1 | 255 | 1 |
| AW00017602 | 127 | 1 | 127 | 1 |
| AW00017666 | 63 | 1 | 63 | 1 |
| AW00017794 | 127 | 1 | 127 | 1 |
| AW00017858 | 63 | 1 | 63 | 1 |
| AW00017986 | 127 | 1 | 127 | 1 |
| AW00018050 | 63 | 1 | 63 | 1 |
| AW00018114 | 63 | 1 | 63 | 1 |
| AW00018178 | 63 | 1 | 63 | 1 |
| AW00018306 | 127 | 1 | 127 | 1 |
| AW00018370 | 63 | 1 | 63 | 1 |
| AW00018498 | 127 | 1 | 127 | 1 |
| AW00018562 | 63 | 1 | 63 | 1 |
| AW00018690 | 127 | 1 | 127 | 1 |
| AW00018818 | 127 | 1 | 127 | 1 |
| AW00018946 | 127 | 1 | 127 | 1 |
| AW00019010 | 63 | 1 | 63 | 1 |
| AW00019074 | 63 | 1 | 63 | 1 |
| AW00019202 | 127 | 1 | 127 | 1 |
| AW00019458 | 255 | 1 | 255 | 1 |
| AW00019522 | 63 | 1 | 63 | 1 |
| AW00019778 | 255 | 1 | 255 | 1 |
| AW00019842 | 63 | 1 | 63 | 1 |
| AW00019970 | 127 | 1 | 127 | 1 |
| AW00020098 | 127 | 1 | 127 | 1 |
| AW00020162 | 63 | 1 | 63 | 1 |
| AW00020290 | 127 | 1 | 127 | 1 |
| AW00020354 | 63 | 1 | 63 | 1 |
| AW00020482 | 127 | 1 | 127 | 1 |
| AW00020610 | 127 | 1 | 127 | 1 |
| AW00020738 | 127 | 1 | 127 | 1 |
| AW00020802 | 63 | 1 | 63 | 1 |
| AW00020930 | 127 | 1 | 127 | 1 |
| AW00020994 | 63 | 1 | 63 | 1 |
| AW00021058 | 63 | 1 | 63 | 1 |
| AW00021122 | 63 | 1 | 63 | 1 |
| AW00021186 | 63 | 1 | 63 | 1 |
| AW00021314 | 127 | 1 | 127 | 1 |
| AW00021442 | 127 | 1 | 127 | 1 |
| AW00021506 | 63 | 1 | 63 | 1 |
| AW00021570 | 63 | 1 | 63 | 1 |
| AW00021634 | 63 | 1 | 63 | 1 |
| AW00021762 | 127 | 1 | 127 | 1 |
| AW00021826 | 63 | 1 | 63 | 1 |
| AW00021954 | 127 | 1 | 127 | 1 |
| AW00022018 | 63 | 1 | 63 | 1 |
| AW00022146 | 127 | 1 | 127 | 1 |
| AW00022914 | 767 | 1 | 767 | 1 |
| AW00023010 | 95 | 1 | 95 | 1 |
| AW00023202 | 191 | 1 | 191 | 1 |
| AW00023298 | 95 | 1 | 95 | 1 |
| AW00023970 | 671 | 1 | 671 | 1 |
| AW00024066 | 95 | 1 | 95 | 1 |
| AW00024738 | 671 | 1 | 671 | 1 |
| AW00024994 | 255 | 1 | 255 | 1 |
| AW00025122 | 127 | 1 | 127 | 1 |
| AW00025378 | 255 | 1 | 255 | 1 |
| AW00025506 | 127 | 1 | 127 | 1 |
| AW00025890 | 383 | 1 | 383 | 1 |
| AW00026018 | 127 | 1 | 127 | 1 |
| AW00026274 | 255 | 1 | 255 | 1 |
| AW00026402 | 127 | 1 | 127 | 1 |
| AW00026786 | 383 | 1 | 383 | 1 |
| AW00026914 | 127 | 1 | 127 | 1 |
| AW00027042 | 127 | 1 | 127 | 1 |
| AW00027298 | 255 | 1 | 255 | 1 |
| AW00027426 | 127 | 1 | 127 | 1 |
| AW00027682 | 255 | 1 | 255 | 1 |
| AW00027810 | 127 | 1 | 127 | 1 |
| AW00027938 | 127 | 1 | 127 | 1 |
| AW00028066 | 127 | 1 | 127 | 1 |
| AW00028194 | 127 | 1 | 127 | 1 |
| AW00028322 | 127 | 1 | 127 | 1 |
| AW00028578 | 255 | 1 | 255 | 1 |
| AW00028706 | 127 | 1 | 127 | 1 |
| AW00028962 | 255 | 1 | 255 | 1 |
| AW00029090 | 127 | 1 | 127 | 1 |
| AW00029218 | 127 | 1 | 127 | 1 |
| AW00029474 | 255 | 1 | 255 | 1 |
| AW00029602 | 127 | 1 | 127 | 1 |
| AW00029986 | 383 | 1 | 383 | 1 |
| AW00030114 | 127 | 1 | 127 | 1 |
| AW00030117 | 2 | 1 | 2 | 1 |
| AW00030118 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| IX_Customer_TerritoryID | Aug 8 2010 5:23PM | 19820 | 19820 | 10 | 0 | 8 |
|
19820 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.1 | 4 | TerritoryID |
| 5.045409E-05 | 8 | TerritoryID, CustomerID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1 | 0 | 3520 | 0 | 1 |
| 2 | 0 | 113 | 0 | 1 |
| 3 | 0 | 132 | 0 | 1 |
| 4 | 0 | 4696 | 0 | 1 |
| 5 | 0 | 176 | 0 | 1 |
| 6 | 0 | 1791 | 0 | 1 |
| 7 | 0 | 1884 | 0 | 1 |
| 8 | 0 | 1852 | 0 | 1 |
| 9 | 0 | 3665 | 0 | 1 |
| 10 | 0 | 1991 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000003_2A4B4B5E | Aug 8 2010 5:23PM | 19820 | 19820 | 147 | 0.5027174 | 0.2696266 |
|
19820 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.001424501 | 0.2696266 | StoreID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 18484 | 0 | 1 | |
| 292 | 0 | 2 | 0 | 1 |
| 322 | 28 | 1 | 14 | 2 |
| 346 | 22 | 2 | 11 | 2 |
| 350 | 2 | 2 | 1 | 2 |
| 352 | 0 | 2 | 0 | 1 |
| 378 | 24 | 2 | 12 | 2 |
| 382 | 2 | 2 | 1 | 2 |
| 386 | 2 | 2 | 1 | 2 |
| 390 | 2 | 2 | 1 | 2 |
| 394 | 2 | 2 | 1 | 2 |
| 396 | 0 | 1 | 0 | 1 |
| 398 | 0 | 2 | 0 | 1 |
| 402 | 1 | 1 | 1 | 1 |
| 404 | 0 | 1 | 0 | 1 |
| 408 | 2 | 2 | 1 | 2 |
| 412 | 2 | 2 | 1 | 2 |
| 414 | 0 | 2 | 0 | 1 |
| 416 | 0 | 1 | 0 | 1 |
| 418 | 0 | 2 | 0 | 1 |
| 424 | 4 | 1 | 2 | 2 |
| 426 | 0 | 1 | 0 | 1 |
| 434 | 6 | 1 | 3 | 2 |
| 438 | 2 | 2 | 1 | 2 |
| 442 | 2 | 2 | 1 | 2 |
| 446 | 2 | 2 | 1 | 2 |
| 448 | 0 | 1 | 0 | 1 |
| 452 | 2 | 2 | 1 | 2 |
| 456 | 2 | 2 | 1 | 2 |
| 460 | 1 | 1 | 1 | 1 |
| 462 | 0 | 1 | 0 | 1 |
| 466 | 2 | 2 | 1 | 2 |
| 470 | 1 | 1 | 1 | 1 |
| 474 | 2 | 2 | 1 | 2 |
| 478 | 2 | 2 | 1 | 2 |
| 482 | 2 | 2 | 1 | 2 |
| 484 | 0 | 2 | 0 | 1 |
| 486 | 0 | 1 | 0 | 1 |
| 490 | 2 | 2 | 1 | 2 |
| 494 | 2 | 2 | 1 | 2 |
| 498 | 2 | 2 | 1 | 2 |
| 500 | 0 | 1 | 0 | 1 |
| 504 | 2 | 2 | 1 | 2 |
| 508 | 2 | 2 | 1 | 2 |
| 512 | 2 | 2 | 1 | 2 |
| 516 | 2 | 2 | 1 | 2 |
| 520 | 2 | 2 | 1 | 2 |
| 524 | 2 | 2 | 1 | 2 |
| 528 | 2 | 2 | 1 | 2 |
| 530 | 0 | 1 | 0 | 1 |
| 534 | 2 | 2 | 1 | 2 |
| 538 | 2 | 2 | 1 | 2 |
| 540 | 0 | 2 | 0 | 1 |
| 572 | 30 | 1 | 15 | 2 |
| 574 | 0 | 2 | 0 | 1 |
| 576 | 0 | 1 | 0 | 1 |
| 582 | 4 | 2 | 2 | 2 |
| 586 | 2 | 2 | 1 | 2 |
| 590 | 2 | 2 | 1 | 2 |
| 592 | 0 | 2 | 0 | 1 |
| 594 | 0 | 1 | 0 | 1 |
| 598 | 2 | 2 | 1 | 2 |
| 602 | 2 | 2 | 1 | 2 |
| 604 | 0 | 2 | 0 | 1 |
| 606 | 0 | 1 | 0 | 1 |
| 610 | 2 | 2 | 1 | 2 |
| 614 | 2 | 2 | 1 | 2 |
| 618 | 2 | 2 | 1 | 2 |
| 622 | 2 | 2 | 1 | 2 |
| 626 | 2 | 2 | 1 | 2 |
| 630 | 2 | 2 | 1 | 2 |
| 634 | 2 | 2 | 1 | 2 |
| 638 | 2 | 2 | 1 | 2 |
| 642 | 2 | 2 | 1 | 2 |
| 644 | 0 | 2 | 0 | 1 |
| 646 | 0 | 1 | 0 | 1 |
| 650 | 2 | 2 | 1 | 2 |
| 654 | 2 | 2 | 1 | 2 |
| 658 | 2 | 2 | 1 | 2 |
| 662 | 2 | 2 | 1 | 2 |
| 666 | 2 | 2 | 1 | 2 |
| 670 | 2 | 2 | 1 | 2 |
| 672 | 0 | 2 | 0 | 1 |
| 674 | 0 | 1 | 0 | 1 |
| 676 | 0 | 2 | 0 | 1 |
| 680 | 1 | 1 | 1 | 1 |
| 684 | 2 | 2 | 1 | 2 |
| 686 | 0 | 2 | 0 | 1 |
| 712 | 24 | 1 | 12 | 2 |
| 744 | 30 | 2 | 15 | 2 |
| 746 | 0 | 2 | 0 | 1 |
| 752 | 2 | 2 | 2 | 1 |
| 754 | 0 | 2 | 0 | 1 |
| 756 | 0 | 1 | 0 | 1 |
| 852 | 94 | 2 | 47 | 2 |
| 866 | 12 | 1 | 6 | 2 |
| 898 | 30 | 2 | 15 | 2 |
| 918 | 18 | 1 | 9 | 2 |
| 950 | 30 | 2 | 15 | 2 |
| 956 | 4 | 1 | 2 | 2 |
| 968 | 10 | 1 | 5 | 2 |
| 1000 | 30 | 2 | 15 | 2 |
| 1006 | 4 | 1 | 2 | 2 |
| 1008 | 0 | 1 | 0 | 1 |
| 1040 | 30 | 2 | 15 | 2 |
| 1058 | 16 | 1 | 8 | 2 |
| 1090 | 30 | 2 | 15 | 2 |
| 1098 | 6 | 1 | 3 | 2 |
| 1104 | 4 | 1 | 2 | 2 |
| 1124 | 18 | 1 | 9 | 2 |
| 1180 | 54 | 1 | 27 | 2 |
| 1190 | 8 | 1 | 4 | 2 |
| 1192 | 0 | 2 | 0 | 1 |
| 1194 | 0 | 1 | 0 | 1 |
| 1208 | 12 | 1 | 6 | 2 |
| 1222 | 12 | 1 | 6 | 2 |
| 1224 | 0 | 2 | 0 | 1 |
| 1226 | 0 | 1 | 0 | 1 |
| 1258 | 30 | 2 | 15 | 2 |
| 1264 | 4 | 1 | 2 | 2 |
| 1266 | 0 | 2 | 0 | 1 |
| 1268 | 0 | 1 | 0 | 1 |
| 1300 | 30 | 2 | 15 | 2 |
| 1314 | 12 | 1 | 6 | 2 |
| 1346 | 30 | 2 | 15 | 2 |
| 1348 | 0 | 1 | 0 | 1 |
| 1360 | 10 | 1 | 5 | 2 |
| 1390 | 28 | 1 | 14 | 2 |
| 1402 | 10 | 1 | 5 | 2 |
| 1434 | 30 | 2 | 15 | 2 |
| 1446 | 10 | 1 | 5 | 2 |
| 1452 | 4 | 1 | 2 | 2 |
| 1484 | 30 | 2 | 15 | 2 |
| 1486 | 0 | 2 | 0 | 1 |
| 1488 | 0 | 1 | 0 | 1 |
| 1800 | 6 | 1 | 3 | 2 |
| 1820 | 18 | 1 | 9 | 2 |
| 1848 | 26 | 1 | 13 | 2 |
| 1854 | 4 | 1 | 2 | 2 |
| 1886 | 30 | 2 | 15 | 2 |
| 1908 | 20 | 1 | 10 | 2 |
| 1920 | 10 | 1 | 5 | 2 |
| 1922 | 0 | 1 | 0 | 1 |
| 1942 | 18 | 1 | 9 | 2 |
| 1974 | 30 | 1 | 15 | 2 |
| 1994 | 18 | 2 | 9 | 2 |
| 2051 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000002_2A4B4B5E | Aug 8 2010 5:23PM | 19820 | 19820 | 8 | 1 | 3.858527 |
|
19820 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.230126E-05 | 3.858527 | PersonID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 701 | 0 | 1 | |
| 291 | 0 | 1 | 0 | 1 |
| 1297 | 454 | 1 | 454 | 1 |
| 1738 | 127 | 1 | 127 | 1 |
| 1901 | 95 | 1 | 95 | 1 |
| 2402 | 63 | 1 | 63 | 1 |
| 20776 | 18373 | 1 | 18373 | 1 |
| 20777 | 0 | 1 | 0 | 1 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON SET ARITHABORT ON CREATE TABLE [Sales].[Customer]( [CustomerID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [PersonID] [int] NULL, [StoreID] [int] NULL, [TerritoryID] [int] NULL, [AccountNumber] AS (isnull('AW'+[dbo].[ufnLeadingZeros]([CustomerID]),'')), [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CustomerID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Foreign key to Person.BusinessEntityID' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PersonID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Foreign key to Store.BusinessEntityID' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StoreID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'TerritoryID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique number identifying the customer assigned by the accounting system.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'AccountNumber' 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'Sales', @level1type=N'TABLE',@level1name=N'Customer', @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'Sales', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Current customer information. Also see the Person and Store tables.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'Customer' |