table icon 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 true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
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 false false false
2 Name Name false false false
3 CountryRegionCode nvarchar(3) false false false
4 Group nvarchar(50) false false false
5 SalesYTD money false false false
6 SalesLastYear money false false false
7 CostYTD money false false false
8 CostLastYear money false false false
9 rowguid uniqueidentifier false false false
10 ModifiedDate datetime false false false

Identity Columns

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

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_SalesTerritory_TerritoryID false 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)) false false false true false
CK_SalesTerritory_SalesLastYear 6 SalesLastYear ([SalesLastYear]>=(0.00)) false false false true false
CK_SalesTerritory_CostYTD 7 CostYTD ([CostYTD]>=(0.00)) false false false true false
CK_SalesTerritory_CostLastYear 8 CostLastYear ([CostLastYear]>=(0.00)) false false false true false

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)) false MS_Description Default constraint value of 0.0
DF_SalesTerritory_SalesLastYear SalesLastYear ((0.00)) false MS_Description Default constraint value of 0.0
DF_SalesTerritory_CostYTD CostYTD ((0.00)) false MS_Description Default constraint value of 0.0
DF_SalesTerritory_CostLastYear CostLastYear ((0.00)) false MS_Description Default constraint value of 0.0
DF_SalesTerritory_rowguid rowguid (newid()) false MS_Description Default constraint value of NEWID()
DF_SalesTerritory_ModifiedDate ModifiedDate (getdate()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_SalesTerritory_TerritoryID CLUSTERED true true false false false
AK_SalesTerritory_Name NONCLUSTERED false true false false false
AK_SalesTerritory_rowguid NONCLUSTERED false true false false false

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 false false false No action No action false Sales.Customer
FK_SalesOrderHeader_SalesTerritory_TerritoryID 1 false false false No action No action false Sales.SalesOrderHeader
FK_SalesPerson_SalesTerritory_TerritoryID 1 false false false No action No action false Sales.SalesPerson
FK_SalesTerritoryHistory_SalesTerritory_TerritoryID 1 false false false No action No action false Sales.SalesTerritoryHistory
FK_StateProvince_SalesTerritory_TerritoryID 1 false false false No action No action false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_SalesTerritory_TerritoryID Aug 8 2010 5:23PM 10 10 6 1 4 false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_SalesTerritory_Name Aug 8 2010 5:23PM 10 10 10 0 21 true 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_SalesTerritory_rowguid Aug 8 2010 5:23PM 10 10 9 1 20 false 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000003_634EBE90 Aug 8 2010 5:23PM 10 10 6 0 4 true 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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000004_634EBE90 Jul 18 2011 12:18AM 10 10 3 0 20.6 true 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]

Objects on which [SalesTerritory] depends

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