Sales.SalesTaxRate

Columns

• //

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

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

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

  //

  CONSTRAINT: Check constraint [TaxType] BETWEEN (1) AND (3)

  ([TaxType]>=(1) AND [TaxType]<=(3))
• //

  ${escapify(column.description)}
  TaxRate
  [smallmoney] NOT NULL DEFAULT ((0.00))
• //

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

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) 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_SalesTaxRate_SalesTaxRateID
  UNIQUE CLUSTERED
  SalesTaxRateID
• //

  Unique nonclustered index.
  AK_SalesTaxRate_StateProvinceID_TaxType
  UNIQUE NONCLUSTERED
  StateProvinceID , TaxType
• //

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

Foreign Keys

• //

  Foreign key constraint referencing StateProvince.StateProvinceID.
  FK_SalesTaxRate_StateProvince_StateProvinceID
  Person.StateProvince
  StateProvinceID ⥱ StateProvinceID

Sample Data