Table Customers


Figure A.5. Schema for Table Customers.

graphics/apafig05.gif

Index Name

Fields

Clustered

Primary Key

PK_Customers

CustomerID

Y

Y

City

City

N

N

CompanyName

CompanyName

N

N

PostalCode

PostalCode

N

N

Region

Region

N

N

Foreign Key Name

Key Field

Related Table

Related Field

FK_Orders_Customers

CustomerID

Orders

CustomerID

FK_CustomerCustomer Demo_Customers

CustomerID

Customer CustomerDemo

CustomerID



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