Primary key (clustered) constraint
File Group | PRIMARY |
Space Used | 8.00 KB |
Fill Factor | 0 |
Do not Recompute Statistics | |
Full Text Key | |
Clustered Index | |
Primary Key Index | |
Unique Index | |
Pad Index |
Column | Description | Sort Order | |
---|---|---|---|
BusinessEntityID | Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID. | Ascending | |
StartDate | Primary key. Date the sales representive started work in the territory. | Ascending | |
TerritoryID | Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID. | Ascending |
Average key length | 16.00 |
Density | 1.00 |
Rows in the Table | 17 |
Rows Sampled | 17 |
Distribution Steps | 8 |
Updated | Oct 27 2017 2:33PM |
Sales.SalesTerritoryHistory Table
Sales Schema
AdventureWorks Database