Table 'Sales.SalesTerritory', Sales territory lookup table.

Table 'Sales.SalesTerritory', Sales territory lookup table.

Property NameProperty Value
Records10
Fields10
Record size (bytes) w/o BLOBs326

Field statistics for 'TerritoryID' int identity

Field propertyProperty Value
Minimum value1
Maximum value10
Average value5.5
Values variance9.1666666666666661
Unique values10

Field statistics for 'Name' Name

Field propertyProperty Value
Minimum valueAustralia
Maximum valueUnited Kingdom
Unique values10

Field statistics for 'CountryRegionCode' nvarchar(3)

Field propertyProperty Value
Minimum valueAU
Maximum valueUS
Unique values6

Field statistics for 'Group' nvarchar(50)

Field propertyProperty Value
Minimum valueEurope
Maximum valuePacific
Unique values3

Field statistics for 'SalesYTD' money(19,4)

Field propertyProperty Value
Minimum value1977474.8096
Maximum value8351296.7411
Average value4429402.6133399997
Values variance4129488598750.7881
Unique values10

Field statistics for 'SalesLastYear' money(19,4)

Field propertyProperty Value
Minimum value1307949.7917
Maximum value5693988.8600
Average value3271535.5435299994
Values variance2120582751478.3699
Unique values10

Field statistics for 'CostYTD' money(19,4)

Field propertyProperty Value
Minimum value.0000
Maximum value.0000
Average value0.0
Values variance0.0
Unique values1

Field statistics for 'CostLastYear' money(19,4)

Field propertyProperty Value
Minimum value.0000
Maximum value.0000
Average value0.0
Values variance0.0
Unique values1

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values10

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