Properties

Owner: Sales 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 40 
Rows: 29 
Description: Tax rate lookup table. 

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    SalesTaxRateID  int          Primary key for SalesTaxRate records. 
    StateProvinceID  int          State, province, or country/region the sales tax applies to. 
    TaxType  tinyint          1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. 
    TaxRate  smallmoney    ((0.00))      Tax rate amount. 
    Name  Name  100          Tax rate description. 
    rowguid  uniqueidentifier  16    (newid())      ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 7 column(s)

Identity column

Name Seed Increment Not for replication
  SalesTaxRateID   

Indexes

Index Primary Unique Description
  PK_SalesTaxRate_SalesTaxRateID      Primary key (clustered) constraint 
  AK_SalesTaxRate_StateProvinceID_TaxType      Unique nonclustered index. 
  AK_SalesTaxRate_rowguid      Unique nonclustered index. Used to support replication samples. 
Total: 3 index(es)

Check Constraints

Name Expression
  CK_SalesTaxRate_TaxType  ([TaxType]>=(1) AND [TaxType]<=(3)) 
Total: 1 constraint(s)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Person.StateProvince  FK_SalesTaxRate_StateProvince_StateProvinceID  PK_StateProvince_StateProvinceID 
Total: 1 table(s)

Objects that [Sales].[SalesTaxRate] depends on

Object Name Owner Object Type Dep Level
  Flag  dbo  User Defined type 
  Name  dbo  User Defined type 
  CountryRegion  Person  Table 
  SalesTerritory  Sales  Table 
  StateProvince  Person  Table 
Total: 5 object(s)

SQL

CREATE TABLE [SalesTaxRate] (
    [SalesTaxRateID] [int] IDENTITY (1, 1) NOT NULL ,
    [StateProvinceID] [int] NOT NULL ,
    [TaxType] [tinyint] NOT NULL ,
    [TaxRate] [smallmoney] NOT NULL CONSTRAINT [DF_SalesTaxRate_TaxRate] DEFAULT ((0.00)),
    [Name] [Name] NOT NULL ,
    [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT [DF_SalesTaxRate_rowguid] DEFAULT (newid()),
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_SalesTaxRate_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_SalesTaxRate_SalesTaxRateID] PRIMARY KEY  CLUSTERED
    (
        [SalesTaxRateID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_SalesTaxRate_StateProvince_StateProvinceID] FOREIGN KEY
    (
        [StateProvinceID]
    ) REFERENCES [StateProvince] (
        [StateProvinceID]
    ),
    CONSTRAINT [CK_SalesTaxRate_TaxType] CHECK ([TaxType]>=(1) AND [TaxType]<=(3))
) ON [PRIMARY]
GO


See Also

List of tables