Sales.SpecialOfferProduct

Columns

• //

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

  ${escapify(column.description)}
  ProductID
  [int] NOT 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_SpecialOfferProduct_SpecialOfferID_ProductID
  UNIQUE CLUSTERED
  SpecialOfferID , ProductID
• //

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

  Nonclustered index.
  IX_SpecialOfferProduct_ProductID
  NONCLUSTERED
  ProductID

Foreign Keys

• //

  Foreign key constraint referencing Product.ProductID.
  FK_SpecialOfferProduct_Product_ProductID
  Production.Product
  ProductID ⥱ ProductID
• //

  Foreign key constraint referencing SpecialOffer.SpecialOfferID.
  FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID
  Sales.SpecialOffer
  SpecialOfferID ⥱ SpecialOfferID

Sample Data