Sales.SalesTerritory

Columns

• //

  ${escapify(column.description)}
  TerritoryID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  Name
  [Name] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  CountryRegionCode
  [nvarchar](3) NOT NULL
• //

  ${escapify(column.description)}
  Group
  [nvarchar](50) NOT NULL
• //

  ${escapify(column.description)}
  SalesYTD
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [SalesYTD] >= (0.00)

  ([SalesYTD]>=(0.00))
• //

  ${escapify(column.description)}
  SalesLastYear
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [SalesLastYear] >= (0.00)

  ([SalesLastYear]>=(0.00))
• //

  ${escapify(column.description)}
  CostYTD
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [CostYTD] >= (0.00)

  ([CostYTD]>=(0.00))
• //

  ${escapify(column.description)}
  CostLastYear
  [money] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [CostLastYear] >= (0.00)

  ([CostLastYear]>=(0.00))
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_SalesTerritory_TerritoryID
  UNIQUE CLUSTERED
  TerritoryID
• //

  Unique nonclustered index.
  AK_SalesTerritory_Name
  UNIQUE NONCLUSTERED
  Name
• //

  Unique nonclustered index. Used to support replication samples.
  AK_SalesTerritory_rowguid
  UNIQUE NONCLUSTERED
  rowguid

Foreign Keys

• //

  Foreign key constraint referencing CountryRegion.CountryRegionCode.
  FK_SalesTerritory_CountryRegion_CountryRegionCode
  Person.CountryRegion
  CountryRegionCode ⥱ CountryRegionCode

Sample Data