XML and SQL Server 2000

Figure A.5. Schema for Table Customers.

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

Категории