Orders

Table Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
ID	21575115
Located On	PRIMARY
Data Size KB	160 KB
Index Size KB	320 KB
Rows	830

Creation Options

Name	Value
QUOTED_IDENTIFIER	ON
ANSI_NULLS	ON
ANSI_PADDING	ON

Columns

Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
OrderID		int	4
CustomerID		nchar	5
EmployeeID		int	4
OrderDate		datetime	8
RequiredDate		datetime	8
ShippedDate		datetime	8
ShipVia		int	4
Freight		money	8		(0)
ShipName		nvarchar	40
ShipAddress		nvarchar	60
ShipCity		nvarchar	15
ShipRegion		nvarchar	15
ShipPostalCode		nvarchar	10
ShipCountry		nvarchar	15

Total: 14 column(s)

Indexes

Index	Primary	Unique
PK_Orders
CustomerID
CustomersOrders
EmployeeID
EmployeesOrders
OrderDate
ShippedDate
ShippersOrders
ShipPostalCode

Fulltext Index

No fulltext index exist

Statistics

No statistics exist

Check Constraints

No check constraints exist

Identity Column

	Name	Seed	Increment	Not for replication
	OrderID	1	1

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	[Order Details]	FK_Order_Details_Orders	PK_Orders

Total: 1 table(s)

Referenced Tables

Table	Primary Key or Unique Constraint	Foreign Key
Customers	PK_Customers	FK_Orders_Customers
Employees	PK_Employees	FK_Orders_Employees
Shippers	PK_Shippers	FK_Orders_Shippers

Total: 3 table(s)

Objects that depend on Orders

Object Name	Object Type	Dep Level
CustOrderHist	Procedure	1
CustOrdersOrders	Procedure	1
[Employee Sales by Country]	Procedure	1
Invoices	View	1
[Order Details]	Table	1
[Orders Qry]	View	1
[Product Sales for 1997]	View	1
[Quarterly Orders]	View	1
[Sales by Category]	View	1
[Sales by Year]	Procedure	1
[Sales Totals by Amount]	View	1
SalesByCategory	Procedure	1
[Summary of Sales by Quarter]	View	1
[Summary of Sales by Year]	View	1
[Category Sales for 1997]	View	2
CustOrdersDetail	Procedure	2
[Order Details Extended]	View	2
[Order Subtotals]	View	2

Total 18 object(s)

Objects that Orders depends on

Object Name	Object Type	Dep Level
Customers	Table	1
Employees	Table	1
Shippers	Table	1

Total 3 object(s)

Column Level Dependencies

Object Name	Column	Object Type
Customers	CustomerID	Table
Employees	EmployeeID	Table
Shippers	ShipperID	Table

Total 3 column(s)

Graphical Dependencies

Click Here to view Dependencies Graphically

Extended Properties

No extended properties defined

Permissions

No permissions defined

Table Options

Name	Value
Pintable	OFF
Table lock on bulk load	OFF
Insert row lock	OFF
Text in row	0
Large value types out of row	0

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Orders] (
        [OrderID]            int NOT NULL IDENTITY(1, 1),
        [CustomerID]         nchar(5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [EmployeeID]         int NULL,
        [OrderDate]          datetime NULL,
        [RequiredDate]       datetime NULL,
        [ShippedDate]        datetime NULL,
        [ShipVia]            int NULL,
        [Freight]            money NULL,
        [ShipName]           nvarchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ShipAddress]        nvarchar(60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ShipCity]           nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ShipRegion]         nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ShipPostalCode]     nvarchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ShipCountry]        nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Orders]
    ADD
    CONSTRAINT [PK_Orders]
    PRIMARY KEY
    ([OrderID])
    ON [PRIMARY]
GO
ALTER TABLE [dbo].[Orders]
    ADD
    CONSTRAINT [DF_Orders_Freight]
    DEFAULT (0) FOR [Freight]
GO
ALTER TABLE [dbo].[Orders]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Orders_Customers]
    FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID])
ALTER TABLE [dbo].[Orders]
    CHECK CONSTRAINT [FK_Orders_Customers]

GO
ALTER TABLE [dbo].[Orders]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Orders_Employees]
    FOREIGN KEY ([EmployeeID]) REFERENCES [dbo].[Employees] ([EmployeeID])
ALTER TABLE [dbo].[Orders]
    CHECK CONSTRAINT [FK_Orders_Employees]

GO
ALTER TABLE [dbo].[Orders]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Orders_Shippers]
    FOREIGN KEY ([ShipVia]) REFERENCES [dbo].[Shippers] ([ShipperID])
ALTER TABLE [dbo].[Orders]
    CHECK CONSTRAINT [FK_Orders_Shippers]

GO
CREATE INDEX [CustomerID]
    ON [dbo].[Orders] ([CustomerID])
    ON [PRIMARY]
GO
CREATE INDEX [CustomersOrders]
    ON [dbo].[Orders] ([CustomerID])
    ON [PRIMARY]
GO
CREATE INDEX [EmployeeID]
    ON [dbo].[Orders] ([EmployeeID])
    ON [PRIMARY]
GO
CREATE INDEX [EmployeesOrders]
    ON [dbo].[Orders] ([EmployeeID])
    ON [PRIMARY]
GO
CREATE INDEX [OrderDate]
    ON [dbo].[Orders] ([OrderDate])
    ON [PRIMARY]
GO
CREATE INDEX [ShippedDate]
    ON [dbo].[Orders] ([ShippedDate])
    ON [PRIMARY]
GO
CREATE INDEX [ShippersOrders]
    ON [dbo].[Orders] ([ShipVia])
    ON [PRIMARY]
GO
CREATE INDEX [ShipPostalCode]
    ON [dbo].[Orders] ([ShipPostalCode])
    ON [PRIMARY]
GO