Properties

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

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		SalesTaxRateID	int	4					Primary key for SalesTaxRate records.
		StateProvinceID	int	4					State, province, or country/region the sales tax applies to.
		TaxType	tinyint	1					1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
		TaxRate	smallmoney	4		((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	8		(getdate())			Date and time the record was last updated.

Total: 7 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	SalesTaxRateID	1	1

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	1
	Name	dbo	User Defined type	1
	CountryRegion	Person	Table	2
	SalesTerritory	Sales	Table	2
	StateProvince	Person	Table	3

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