Table: SalesTerritoryHistory Table: SalesTerritoryHistory| Property | Value |
|---|---|
| Name | SalesTerritoryHistory |
| ID | 1842105603 |
| Owner | dbo |
| Schema | Sales |
| Filegroup | PRIMARY |
| Data Size (KB) | 8 KB |
| Index Size (KB) | 24 KB |
| Rows | 17 |
| 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:43 PM |
| Create Date | 8/8/2010 5:21:53 PM |
| Name | Value |
|---|---|
| MS_Description | Sales representative transfers to other sales territories. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | BusinessEntityID | int |
|
|
|
| 2 | TerritoryID | int |
|
|
|
| 3 | StartDate | datetime |
|
|
|
| 4 | EndDate | datetime |
|
|
|
| 5 | rowguid | uniqueidentifier |
|
|
|
| 6 | ModifiedDate | datetime |
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| BusinessEntityID |
| TerritoryID |
| StartDate |
| Name | Referenced Object | Update Action | Delete Action |
|---|---|---|---|
| FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID | Sales.SalesPerson | No action | No action |
| FK_SalesTerritoryHistory_SalesTerritory_TerritoryID | Sales.SalesTerritory | No action | No action |
| Name | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named |
|---|---|---|---|---|---|---|
| CK_SalesTerritoryHistory_EndDate | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |
|
|
|
|
|
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_SalesTerritoryHistory_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_SalesTerritoryHistory_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID | CLUSTERED |
|
|
|
|
|
| AK_SalesTerritoryHistory_rowguid | NONCLUSTERED |
|
|
|
|
|
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID | Aug 8 2010 5:23PM | 17 | 17 | 8 | 1 | 16 |
|
17 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.07142857 | 4 | BusinessEntityID |
| 0.05882353 | 12 | BusinessEntityID, StartDate |
| 0.05882353 | 16 | BusinessEntityID, StartDate, TerritoryID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 275 | 0 | 2 | 0 | 1 |
| 276 | 0 | 1 | 0 | 1 |
| 277 | 0 | 2 | 0 | 1 |
| 279 | 1 | 1 | 1 | 1 |
| 281 | 1 | 1 | 1 | 1 |
| 282 | 0 | 2 | 0 | 1 |
| 284 | 1 | 1 | 1 | 1 |
| 290 | 3 | 1 | 3 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_SalesTerritoryHistory_rowguid | Aug 8 2010 5:23PM | 17 | 17 | 16 | 1 | 32 |
|
17 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.05882353 | 16 | rowguid |
| 0.05882353 | 20 | rowguid, BusinessEntityID |
| 0.05882353 | 28 | rowguid, BusinessEntityID, StartDate |
| 0.05882353 | 32 | rowguid, BusinessEntityID, StartDate, TerritoryID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| fd3f5566-10e2-4960-be12-0365e5665881 | 0 | 1 | 0 | 1 |
| 987613ed-33d6-42a6-b992-0b33e9234934 | 0 | 1 | 0 | 1 |
| 132e4721-32dd-4a73-b556-1837f3a2b9ae | 0 | 1 | 0 | 1 |
| b7c8f9f5-5fb8-47b3-be73-1b9a14bdf8b9 | 0 | 1 | 0 | 1 |
| 57d1cdcf-62ce-499f-8be8-1bb71c4bb7ef | 0 | 1 | 0 | 1 |
| 2c9f5240-d8bf-4f85-897d-6083146dbc4b | 1 | 1 | 1 | 1 |
| d664d989-2beb-4f2c-a4aa-691018965283 | 0 | 1 | 0 | 1 |
| 3e1360cb-32e0-4286-8d98-8539f1ab2550 | 0 | 1 | 0 | 1 |
| 3e9f893d-5142-46c9-a76a-867d1e3d6f90 | 0 | 1 | 0 | 1 |
| ed12f921-8023-48ef-84bd-94d942f4c009 | 0 | 1 | 0 | 1 |
| 92375465-38c6-4c86-aba1-9838a2969475 | 0 | 1 | 0 | 1 |
| 009f7660-44a6-4adf-bd4b-a5d1b79993f5 | 0 | 1 | 0 | 1 |
| 8895e74d-6d38-4140-bbea-a8136a2f480e | 0 | 1 | 0 | 1 |
| 2f44304c-ee87-4c72-813e-ca75c5f61f4c | 0 | 1 | 0 | 1 |
| 64bcb1b3-a793-40ba-9859-d90f78c3f167 | 0 | 1 | 0 | 1 |
| 9d8754b2-c320-40db-a77f-ff5a1bc0f46b | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000002_6DCC4D03 | Aug 8 2010 5:23PM | 17 | 17 | 7 | 0.75 | 4 |
|
17 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.1 | 4 | TerritoryID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1 | 0 | 3 | 0 | 1 |
| 3 | 2 | 2 | 1 | 2 |
| 4 | 0 | 2 | 0 | 1 |
| 5 | 0 | 1 | 0 | 1 |
| 6 | 0 | 3 | 0 | 1 |
| 8 | 1 | 1 | 1 | 1 |
| 10 | 1 | 1 | 1 | 1 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[SalesTerritoryHistory]( [BusinessEntityID] [int] NOT NULL, [TerritoryID] [int] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritoryHistory', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritoryHistory', @level2type=N'COLUMN',@level2name=N'TerritoryID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Date the sales representive started work in the territory.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritoryHistory', @level2type=N'COLUMN',@level2name=N'StartDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the sales representative left work in the territory.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritoryHistory', @level2type=N'COLUMN',@level2name=N'EndDate' 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'SalesTerritoryHistory', @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'SalesTerritoryHistory', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales representative transfers to other sales territories.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritoryHistory' |