Properties

Owner: dbo 
Creation Date: 08/06/2000 
Located On: PRIMARY 
Data Size KB: 160 
Index Size KB: 312 
Rows: 830 
Description:  

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    OrderID  int           
    CustomerID  nchar  10           
    EmployeeID  int           
    OrderDate  datetime           
    RequiredDate  datetime           
    ShippedDate  datetime           
    ShipVia  int           
    Freight  money    (0)       
    ShipName  nvarchar  80           
    ShipAddress  nvarchar  120           
    ShipCity  nvarchar  30           
    ShipRegion  nvarchar  30           
    ShipPostalCode  nvarchar  20           
    ShipCountry  nvarchar  30           
Total: 14 column(s)

Identity column

Name Seed Increment Not for replication
  OrderID   

Indexes

Index Primary Unique Description
  PK_Orders       
  CustomerID       
  CustomersOrders       
  EmployeeID       
  EmployeesOrders       
  OrderDate       
  ShippedDate       
  ShippersOrders       
  ShipPostalCode       
Total: 9 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.Order Details  FK_Order_Details_Orders  PK_Orders 
Total: 1 table(s)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.Customers  FK_Orders_Customers  PK_Customers 
  dbo.Employees  FK_Orders_Employees  PK_Employees 
  dbo.Shippers  FK_Orders_Shippers  PK_Shippers 
Total: 3 table(s)

Objects that [dbo].[Orders] depends on

Object Name Owner Object Type Dep Level
  Customers  dbo  Table 
  Employees  dbo  Table 
  Shippers  dbo  Table 
Total: 3 object(s)

Objects that depend on [dbo].[Orders]

Object Name Owner Object Type Dep Level
  Orders Qry  dbo  View 
  Quarterly Orders  dbo  View 
  Order Details  dbo  Table 
  CustOrdersOrders  dbo  Procedure 
  Invoices  dbo  View 
  Order Details Extended  dbo  View 
  Order Subtotals  dbo  View 
  Product Sales for 1997  dbo  View 
  CustOrderHist  dbo  Procedure 
  CustOrdersDetail  dbo  Procedure 
  SalesByCategory  dbo  Procedure 
  Category Sales for 1997  dbo  View 
  Sales by Category  dbo  View 
  Sales Totals by Amount  dbo  View 
  Summary of Sales by Quarter  dbo  View 
  Summary of Sales by Year  dbo  View 
  Employee Sales by Country  dbo  Procedure 
  Sales by Year  dbo  Procedure 
Total: 18 object(s)

SQL

CREATE TABLE [Orders] (
    [OrderID] [int] IDENTITY (1, 1) NOT NULL ,
    [CustomerID] [nchar] (5) COLLATE Cyrillic_General_CI_AS NULL ,
    [EmployeeID] [int] NULL ,
    [OrderDate] [datetime] NULL ,
    [RequiredDate] [datetime] NULL ,
    [ShippedDate] [datetime] NULL ,
    [ShipVia] [int] NULL ,
    [Freight] [money] NULL CONSTRAINT [DF_Orders_Freight] DEFAULT (0),
    [ShipName] [nvarchar] (40) COLLATE Cyrillic_General_CI_AS NULL ,
    [ShipAddress] [nvarchar] (60) COLLATE Cyrillic_General_CI_AS NULL ,
    [ShipCity] [nvarchar] (15) COLLATE Cyrillic_General_CI_AS NULL ,
    [ShipRegion] [nvarchar] (15) COLLATE Cyrillic_General_CI_AS NULL ,
    [ShipPostalCode] [nvarchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
    [ShipCountry] [nvarchar] (15) COLLATE Cyrillic_General_CI_AS NULL ,
    CONSTRAINT [PK_Orders] PRIMARY KEY  CLUSTERED
    (
        [OrderID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_Orders_Customers] FOREIGN KEY
    (
        [CustomerID]
    ) REFERENCES [Customers] (
        [CustomerID]
    ),
    CONSTRAINT [FK_Orders_Employees] FOREIGN KEY
    (
        [EmployeeID]
    ) REFERENCES [Employees] (
        [EmployeeID]
    ),
    CONSTRAINT [FK_Orders_Shippers] FOREIGN KEY
    (
        [ShipVia]
    ) REFERENCES [Shippers] (
        [ShipperID]
    )
) ON [PRIMARY]
GO


See Also

List of tables