Sales.Store

Columns

• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NOT NULL
• //

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

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  SalesPersonID
  [int] NULL
• //

  ${escapify(column.description)}
  Demographics
  [xml] NULL
• //

  ${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_Store_BusinessEntityID
  UNIQUE CLUSTERED
  BusinessEntityID
• //

  Unique nonclustered index. Used to support replication samples.
  AK_Store_rowguid
  UNIQUE NONCLUSTERED
  rowguid
• //

  Nonclustered index.
  IX_Store_SalesPersonID
  NONCLUSTERED
  SalesPersonID
• //

  Primary XML index.
  PXML_Store_Demographics
  XML
  Demographics

Foreign Keys

• //

  Foreign key constraint referencing BusinessEntity.BusinessEntityID
  FK_Store_BusinessEntity_BusinessEntityID
  Person.BusinessEntity
  BusinessEntityID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing SalesPerson.SalesPersonID
  FK_Store_SalesPerson_SalesPersonID
  Sales.SalesPerson
  SalesPersonID ⥱ BusinessEntityID

Sample Data