Table 'Sales.SalesTaxRate', Tax rate lookup table.

Table 'Sales.SalesTaxRate', Tax rate lookup table.

Property NameProperty Value
Records29
Fields7
Record size (bytes) w/o BLOBs153

Field statistics for 'SalesTaxRateID' int identity

Field propertyProperty Value
Minimum value1
Maximum value31
Average value16.103448275862068
Values variance88.38177339901479
Unique values29

Field statistics for 'StateProvinceID' int

Field propertyProperty Value
Minimum value1
Maximum value84
Average value43.827586206896555
Values variance732.71921182266021
Unique values26

Field statistics for 'TaxType' tinyint

Field propertyProperty Value
Minimum value1
Maximum value3
Average value2.0
Values variance0.9285714285714286
Unique values3

Field statistics for 'TaxRate' smallmoney(10,4)

Field propertyProperty Value
Minimum value5.0000
Maximum value19.6000
Average value9.091379310344827
Values variance14.235548029556671
Unique values15

Field statistics for 'Name' Name

Field propertyProperty Value
Minimum valueArizona State Sales Tax
Maximum valueWashington State Sales Tax
Unique values18

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values29

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value1998-06-01 00:00:00.000
Maximum value1998-06-01 00:00:00.000
Unique values1