Indices SQL 2005 Adventure Works OLTP

AK_SalesTaxRate_StateProvinceID_TaxType

Object type: Index

Unique nonclustered index.

Details 

Table  Unique  Clustered  XML 
Sales.SalesTaxRate  Yes No No

Columns 

Column  Description 
StateProvinceID  State, province, or country/region the sales tax applies to. 
TaxType  1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. 

Applies to

Indices | Unique | Non clustered
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.