# Table: SalesTerritoryHistory

## Properties

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

## Extended Properties

Name | Value
--- | ---
MS_Description | Sales representative transfers to other sales territories.

## Columns

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 |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

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

## Primary Key Columns

Name
BusinessEntityID
TerritoryID
StartDate

## Foreign Keys

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

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

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) |  |  |  |  |

## Default Constraints

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()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID | CLUSTERED |  |  |  |  |
AK_SalesTerritoryHistory_rowguid | 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_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID | Aug 8 2010 5:23PM | 17 | 17 | 8 | 1 | 16 |  |  | 17

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.07142857 | 4 | BusinessEntityID
0.05882353 | 12 | BusinessEntityID, StartDate
0.05882353 | 16 | BusinessEntityID, StartDate, TerritoryID

### Detailed Statistics Histogram

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

### Detailed Statistics General

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

### Detailed Statistics Density

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

### Detailed Statistics Histogram

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

### Detailed Statistics General

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

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.1 | 4 | TerritoryID

### Detailed Statistics Histogram

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

## Objects that depend on [SalesTerritoryHistory]

- Sales.SalesTerritoryHistory

## Objects on which [SalesTerritoryHistory] depends

- Sales.SalesTerritoryHistory
  - Sales.SalesPerson
    - Sales.SalesTerritory
      - Person.CountryRegion
        - dbo.Name
    - HumanResources.Employee
      - Person.Person
        - Person.AdditionalContactInfoSchemaCollection
        - Person.BusinessEntity
        - Demographics.exist
        - Person.IndividualSurveySchemaCollection
        - dbo.NameStyle
      - dbo.Flag

## SQL

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'

#### See also

List of Tables