Table Orders


Figure A.10. Schema for Table Orders.

graphics/apafig10.gif

Index Name

Fields

Clustered

Primary Key

PK_Orders

OrderID

Y

Y

OrderDate

OrderDate

N

N

ShippedDate

ShippedDate

N

N

ShippersOrders

ShipVia

N

N

ShipPostalCode

ShipPostalCode

N

N

Foreign Key Name

Key Field

Related Table

Related Field

FK_Orders_Customers

CustomerID

Customers

CustomerID

FK_Order_Details_Orders

OrderID

Order Details

OrderID



XML and SQL Server 2000
XML and SQL Server 2000
ISBN: 0735711127
EAN: 2147483647
Year: 2005
Pages: 104
Authors: John Griffin

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net