XML and SQL Server 2000

Figure A.2. Schema for Table Categories.

Index Name

Fields

Clustered

Primary Key

PK_Categories

CategoryID

Y

Y

CategoryName

CategoryName

N

N

Foreign Key

Name Key Field

Related Table

Related Field

FK_Products_Categories

CategoryID

Products

CategoryID

Категории