Name: | Northwind |
Owner: | sa |
Create for Attach: | 08/06/2000 |
Compatibility Level: | 80 |
Recovery Model: | Simple recovery model |
Status: | Database is available for query |
Full Text Search Enabled: | |
Primary File: | D:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf |
Version: | 539 |
Database size, MB: | 4.25 MB |
Allocated Space, KB: | 2504 KB |
Data Space in Use and Reserved for Use, KB: | 976 KB |
Index Space Usage, KB: | 1256 KB |
Allocated and Unused Space, KB: | 272 KB |
Description: |
File Name | Location | File Group | Allocated Space, MB | Autogrows | Grows | Maximum File Size, MB |
Northwind | D:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf | PRIMARY | 3 |
|
10 % | Unrestricted |
File Name | Location | Allocated Space, MB | Autogrows | Grows | Maximum File Size, MB |
Northwind_log | D:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf | 1 |
|
10 % | Unrestricted |
Name | Owner | Data Size KB | Index Size KB | Creation Date | Cols | Rows | Description | |
|
Categories | dbo | 32 | 112 | 08/06/2000 | 4 | 8 | |
|
CustomerCustomerDemo | dbo | 0 | 0 | 08/06/2000 | 2 | 0 | |
|
CustomerDemographics | dbo | 0 | 0 | 08/06/2000 | 2 | 0 | |
|
Customers | dbo | 80 | 24 | 08/06/2000 | 11 | 91 | |
|
Employees | dbo | 48 | 232 | 08/06/2000 | 18 | 9 | |
|
EmployeeTerritories | dbo | 24 | 8 | 08/06/2000 | 2 | 49 | |
|
Order Details | dbo | 208 | 72 | 08/06/2000 | 5 | 2155 | |
|
Orders | dbo | 312 | 160 | 08/06/2000 | 14 | 830 | |
|
Products | dbo | 96 | 8 | 08/06/2000 | 10 | 77 | |
|
Region | dbo | 24 | 8 | 08/06/2000 | 2 | 4 | |
|
Shippers | dbo | 16 | 8 | 08/06/2000 | 3 | 3 | |
|
Suppliers | dbo | 48 | 24 | 08/06/2000 | 12 | 29 | |
|
Territories | dbo | 24 | 8 | 08/06/2000 | 3 | 53 |
Name | Owner | Schema bound | Encrypted | Creation Date | Description | |
|
Alphabetical list of products | dbo |
|
|
08/06/2000 | |
|
Category Sales for 1997 | dbo |
|
|
08/06/2000 | |
|
Current Product List | dbo |
|
|
08/06/2000 | |
|
Customer and Suppliers by City | dbo |
|
|
08/06/2000 | |
|
Invoices | dbo |
|
|
08/06/2000 | |
|
Order Details Extended | dbo |
|
|
08/06/2000 | |
|
Order Subtotals | dbo |
|
|
08/06/2000 | |
|
Orders Qry | dbo |
|
|
08/06/2000 | |
|
Product Sales for 1997 | dbo |
|
|
08/06/2000 | |
|
Products Above Average Price | dbo |
|
|
08/06/2000 | |
|
Products by Category | dbo |
|
|
08/06/2000 | |
|
Quarterly Orders | dbo |
|
|
08/06/2000 | |
|
Sales by Category | dbo |
|
|
08/06/2000 | |
|
Sales Totals by Amount | dbo |
|
|
08/06/2000 | |
|
Summary of Sales by Quarter | dbo |
|
|
08/06/2000 | |
|
Summary of Sales by Year | dbo |
|
|
08/06/2000 |
Name | Owner | Description | |
|
CustOrderHist | dbo | |
|
CustOrdersDetail | dbo | |
|
CustOrdersOrders | dbo | |
|
Employee Sales by Country | dbo | |
|
Sales by Year | dbo | |
|
SalesByCategory | dbo | |
|
Ten Most Expensive Products | dbo |
Settings: Auto Close: | |
Settings: Auto Shrink: | |
Settings: Auto Create Statistics: | |
Settings: Auto Update Statistics: | |
Settings: Use Quoted Identifiers: | |
Settings: Torn Page Detection: | |
Settings: Recursive Triggers: | |
Settings: ANSI NULL default: | |
Access: Read Only: | |
Access: Single User: | |
Access: Members of db_owner, dbcreator or sysadmin: | |
Truncate Log On Checkpoint: | |
Select Into/Bulkcopy: | |
Cursor Close On Commit: | |
Cursors in a Batch are with Local Scope: |
See Also
Server overview