# Table: SalesTerritory

## Properties

Property | Value
--- | ---
Name | SalesTerritory
ID | 1666104976
Owner | dbo
Schema | Sales
Filegroup | PRIMARY
Data Size (KB) | 8 KB
Index Size (KB) | 40 KB
Rows | 10
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 territory lookup table.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | TerritoryID | int |  |  |
2 | Name | Name |  |  |
3 | CountryRegionCode | nvarchar(3) |  |  |
4 | Group | nvarchar(50) |  |  |
5 | SalesYTD | money |  |  |
6 | SalesLastYear | money |  |  |
7 | CostYTD | money |  |  |
8 | CostLastYear | money |  |  |
9 | rowguid | uniqueidentifier |  |  |
10 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
TerritoryID | 1 | 1 | 10 |  |  |  |

## Primary Key Constraints

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

## Primary Key Columns

Name
TerritoryID

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_SalesTerritory_CountryRegion_CountryRegionCode | Person.CountryRegion | No action | No action

## Column Level Check Constraints

Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named
--- | --- | --- | --- | --- | --- | --- | --- | ---
CK_SalesTerritory_SalesYTD | 5 | SalesYTD | ([SalesYTD]>=(0.00)) |  |  |  |  |
CK_SalesTerritory_SalesLastYear | 6 | SalesLastYear | ([SalesLastYear]>=(0.00)) |  |  |  |  |
CK_SalesTerritory_CostYTD | 7 | CostYTD | ([CostYTD]>=(0.00)) |  |  |  |  |
CK_SalesTerritory_CostLastYear | 8 | CostLastYear | ([CostLastYear]>=(0.00)) |  |  |  |  |

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_SalesTerritory_SalesYTD | SalesYTD | ((0.00)) |  | MS_Description | Default constraint value of 0.0
DF_SalesTerritory_SalesLastYear | SalesLastYear | ((0.00)) |  | MS_Description | Default constraint value of 0.0
DF_SalesTerritory_CostYTD | CostYTD | ((0.00)) |  | MS_Description | Default constraint value of 0.0
DF_SalesTerritory_CostLastYear | CostLastYear | ((0.00)) |  | MS_Description | Default constraint value of 0.0
DF_SalesTerritory_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_SalesTerritory_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_SalesTerritory_TerritoryID | CLUSTERED |  |  |  |  |
AK_SalesTerritory_Name | NONCLUSTERED |  |  |  |  |
AK_SalesTerritory_rowguid | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object
--- | --- | --- | --- | --- | --- | --- | --- | ---
FK_Customer_SalesTerritory_TerritoryID | 1 |  |  |  | No action | No action |  | Sales.Customer
FK_SalesOrderHeader_SalesTerritory_TerritoryID | 1 |  |  |  | No action | No action |  | Sales.SalesOrderHeader
FK_SalesPerson_SalesTerritory_TerritoryID | 1 |  |  |  | No action | No action |  | Sales.SalesPerson
FK_SalesTerritoryHistory_SalesTerritory_TerritoryID | 1 |  |  |  | No action | No action |  | Sales.SalesTerritoryHistory
FK_StateProvince_SalesTerritory_TerritoryID | 1 |  |  |  | No action | No action |  | Person.StateProvince

## 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_SalesTerritory_TerritoryID | Aug 8 2010 5:23PM | 10 | 10 | 6 | 1 | 4 |  |  | 10

### 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 | 1 | 0 | 1
3 | 1 | 1 | 1 | 1
5 | 1 | 1 | 1 | 1
7 | 1 | 1 | 1 | 1
9 | 1 | 1 | 1 | 1
10 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_SalesTerritory_Name | Aug 8 2010 5:23PM | 10 | 10 | 10 | 0 | 21 |  |  | 10

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.1 | 17 | Name
0.1 | 21 | Name, TerritoryID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
Australia | 0 | 1 | 0 | 1
Canada | 0 | 1 | 0 | 1
Central | 0 | 1 | 0 | 1
France | 0 | 1 | 0 | 1
Germany | 0 | 1 | 0 | 1
Northeast | 0 | 1 | 0 | 1
Northwest | 0 | 1 | 0 | 1
Southeast | 0 | 1 | 0 | 1
Southwest | 0 | 1 | 0 | 1
United Kingdom | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_SalesTerritory_rowguid | Aug 8 2010 5:23PM | 10 | 10 | 9 | 1 | 20 |  |  | 10

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.1 | 16 | rowguid
0.1 | 20 | rowguid, TerritoryID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
05fc7e1f-2dea-414e-9ecd-09d150516fb5 | 0 | 1 | 0 | 1
00fb7309-96cc-49e2-8363-0a1ba72486f2 | 0 | 1 | 0 | 1
06b4af8a-1639-476e-9266-110461d66b00 | 0 | 1 | 0 | 1
43689a10-e30b-497f-b0de-11de20267ff7 | 0 | 1 | 0 | 1
602e612e-dfe9-41d9-b894-27e489747885 | 0 | 1 | 0 | 1
6dc4165a-5e4c-42d2-809d-4344e0ac75e7 | 0 | 1 | 0 | 1
dc3e9ea0-7950-4431-9428-99dbcbc33865 | 1 | 1 | 1 | 1
6d2450db-8159-414f-a917-e73ee91c38a9 | 0 | 1 | 0 | 1
df6e7fd8-1a8d-468c-b103-ed8addb452c1 | 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_00000003_634EBE90 | Aug 8 2010 5:23PM | 10 | 10 | 6 | 0 | 4 |  |  | 10

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.1666667 | 4 | CountryRegionCode

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
AU | 0 | 1 | 0 | 1
CA | 0 | 1 | 0 | 1
DE | 0 | 1 | 0 | 1
FR | 0 | 1 | 0 | 1
GB | 0 | 1 | 0 | 1
US | 0 | 5 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000004_634EBE90 | Jul 18 2011 12:18AM | 10 | 10 | 3 | 0 | 20.6 |  |  | 10

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.3333333 | 20.6 | Group

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
Europe | 0 | 3 | 0 | 1
North America | 0 | 6 | 0 | 1
Pacific | 0 | 1 | 0 | 1

## Objects that depend on [SalesTerritory]

- Sales.SalesTerritory
  - Person.StateProvince
    - HumanResources.vEmployee
    - Person.Address
      - Person.BusinessEntityAddress
        - Purchasing.vVendorWithAddresses
        - Sales.vIndividualCustomer
        - Sales.vSalesPerson
        - Sales.vStoreWithAddresses
      - Sales.SalesOrderHeader
        - Sales.SalesOrderDetail
          - Sales.iduSalesOrderDetail
          - Sales.ufn_SalesByStore
        - Sales.SalesOrderHeaderSalesReason
        - Sales.uSalesOrderHeader
        - Sales.vSalesPersonSalesByFiscalYears
    - Person.vStateProvinceCountryRegion
    - Sales.SalesTaxRate
  - Sales.Customer
    - dbo.ufnGetContactInformation
  - Sales.SalesPerson
    - Sales.SalesPersonQuotaHistory
    - Sales.SalesTerritoryHistory
    - Sales.Store
      - Sales.vStoreWithContacts
      - Sales.vStoreWithDemographics

## Objects on which [SalesTerritory] depends

- Sales.SalesTerritory
  - Person.CountryRegion
    - dbo.Name

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[SalesTerritory]( [TerritoryID] [int] IDENTITY(1,1) NOT NULL, [Name] [dbo].[Name] NOT NULL, [CountryRegionCode] [nvarchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Group] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SalesYTD] [money] NOT NULL, [SalesLastYear] [money] NOT NULL, [CostYTD] [money] NOT NULL, [CostLastYear] [money] 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 for SalesTerritory records.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'TerritoryID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales territory description' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'Name' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. ' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'CountryRegionCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Geographic area to which the sales territory belong.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'Group' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales in the territory year to date.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'SalesYTD' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales in the territory the previous year.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'SalesLastYear' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business costs in the territory year to date.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'CostYTD' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Business costs in the territory the previous year.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory', @level2type=N'COLUMN',@level2name=N'CostLastYear' 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'SalesTerritory', @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'SalesTerritory', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales territory lookup table.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesTerritory'

#### See also

List of Tables