Production.ProductModel

Columns

• //

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

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

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

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

  ${escapify(column.description)}
  Instructions
  [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_ProductModel_ProductModelID
  UNIQUE CLUSTERED
  ProductModelID
• //

  Unique nonclustered index.
  AK_ProductModel_Name
  UNIQUE NONCLUSTERED
  Name
• //

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

  Primary XML index.
  PXML_ProductModel_CatalogDescription
  XML
  CatalogDescription
• //

  Primary XML index.
  PXML_ProductModel_Instructions
  XML
  Instructions

Sample Data