Table | Rows | Total size, bytes | %% of Database |
---|
Sales.SalesOrderDetail | 121 317 | 16 744 872 | |
Production.WorkOrderRouting | 67 131 | 9 733 995 | |
Production.TransactionHistory | 113 443 | 8 508 225 | |
Sales.SalesOrderHeader | 31 465 | 7 431 047 | |
Production.TransactionHistoryArchive | 89 253 | 6 693 975 | |
Production.WorkOrder | 72 591 | 5 953 920 | |
Person.Contact | 19 972 | 2 957 444 | |
Production.ProductPhoto | 101 | 2 013 474 | |
Person.Address | 19 614 | 1 398 756 | |
Sales.CurrencyRate | 13 532 | 1 217 880 | |
Purchasing.PurchaseOrderDetail | 8 845 | 1 052 555 | |
Sales.Customer | 19 185 | 997 620 | |
Sales.CreditCard | 19 118 | 904 077 | |
Sales.CustomerAddress | 19 220 | 845 680 | |
Sales.SalesOrderHeaderSalesReason | 27 647 | 663 528 | |
Purchasing.PurchaseOrderHeader | 4 012 | 601 800 | |
Sales.ContactCreditCard | 19 118 | 458 832 | |
Sales.Individual | 18 484 | 443 616 | |
Production.Document | 9 | 291 203 | |
dbo.DatabaseLog | 389 | 211 519 | |
Production.BillOfMaterials | 2 679 | 168 870 | |
Production.ProductDescription | 762 | 79 678 | |
Production.Product | 504 | 78 729 | |
Purchasing.ProductVendor | 460 | 46 620 | |
Production.ProductInventory | 1 069 | 45 478 | |
Sales.Store | 701 | 42 147 | |
HumanResources.Employee | 290 | 41 213 | |
Sales.StoreContact | 753 | 33 132 | |
Production.ProductModelProductDescriptionCulture | 762 | 27 432 | |
Production.ProductCostHistory | 395 | 25 715 | |
Production.ProductListPriceHistory | 395 | 25 715 | |
Sales.SpecialOfferProduct | 538 | 21 520 | |
HumanResources.EmployeePayHistory | 316 | 18 328 | |
Production.ProductProductPhoto | 504 | 12 600 | |
Sales.SalesPersonQuotaHistory | 163 | 11 899 | |
HumanResources.EmployeeDepartmentHistory | 296 | 11 640 | |
HumanResources.EmployeeAddress | 290 | 11 600 | |
Person.StateProvince | 181 | 10 576 | |
Person.CountryRegion | 238 | 6 679 | |
Production.ProductModel | 128 | 6 645 | |
Purchasing.Vendor | 104 | 5 601 | |
Production.ProductReview | 4 | 5 225 | |
Purchasing.VendorContact | 156 | 4 368 | |
Sales.Currency | 105 | 3 577 | |
Purchasing.VendorAddress | 104 | 2 912 | |
Sales.CountryRegionCurrency | 109 | 2 616 | |
Sales.SalesPerson | 17 | 2 237 | |
Sales.SalesTaxRate | 29 | 2 108 | |
Sales.SpecialOffer | 16 | 2 100 | |
Production.ProductSubcategory | 37 | 1 809 | |
Sales.SalesTerritory | 10 | 1 408 | |
Production.UnitMeasure | 38 | 1 158 | |
Sales.SalesTerritoryHistory | 17 | 1 016 | |
HumanResources.Department | 16 | 908 | |
Person.ContactType | 20 | 795 | |
Production.ProductDocument | 32 | 768 | |
Production.Location | 14 | 754 | |
Production.ScrapReason | 16 | 629 | |
Purchasing.ShipMethod | 5 | 470 | |
Sales.SalesReason | 10 | 385 | |
Production.Culture | 8 | 305 | |
HumanResources.JobCandidate | 13 | 268 | |
Person.AddressType | 6 | 260 | |
Production.ProductCategory | 4 | 178 | |
Production.ProductModelIllustration | 7 | 168 | |
HumanResources.Shift | 3 | 162 | |
Sales.ShoppingCartItem | 3 | 147 | |
Production.Illustration | 5 | 100 | |
dbo.AWBuildVersion | 1 | 46 | |
dbo.ErrorLog | 0 | 0 | |