Properties

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:  

Data Files

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    10 %  Unrestricted 
Total: 1 data file(s)

Log Files

File Name Location Allocated Space, MB Autogrows Grows Maximum File Size, MB
Northwind_log   D:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf     10 %  Unrestricted 
Total: 1 log file(s)

Tables

Name Owner Data Size KB Index Size KB Creation Date Cols Rows Description
  Categories  dbo  32  112  08/06/2000   
  CustomerCustomerDemo  dbo  08/06/2000   
  CustomerDemographics  dbo  08/06/2000   
  Customers  dbo  80  24  08/06/2000  11  91   
  Employees  dbo  48  232  08/06/2000  18   
  EmployeeTerritories  dbo  24  08/06/2000  49   
  Order Details  dbo  208  72  08/06/2000  2155   
  Orders  dbo  312  160  08/06/2000  14  830   
  Products  dbo  96  08/06/2000  10  77   
  Region  dbo  24  08/06/2000   
  Shippers  dbo  16  08/06/2000   
  Suppliers  dbo  48  24  08/06/2000  12  29   
  Territories  dbo  24  08/06/2000  53   
Total: 13 table(s)

Views

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   
Total: 16 view(s)

Stored procedures

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   
Total: 7 stored procedure(s)

Database Options

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