XML and SQL Server 2000

Figure A.14. Schema for Table Suppliers.

Index Name

Fields

Clustered

Primary Key

PK_Suppliers

SupplierID

Y

Y

CompanyName

CompanyName

N

N

PostalCode

PostalCode

N

N

Foreign Key Name

Key Field

Related Table

Related Field

FK_Products_Suppliers

SupplierID

Products

SupplierID

Категории