Appendix A: The pubs2 Database

roysched table

The roysched table contains royalties, defined as a percentage of price, in the pubs2 database.

roysched is defined as follows:

create table roysched
title_id tid not null,
lorange int null,
hirange int null,
royalty int null)

Its primary key is title_id:

sp_primarykey roysched, title_id

Its title_id column is a foreign key to titles:

sp_foreignkey roysched, titles, title_id

Its nonclustered index for the title_id column is defined as:

create nonclustered index titleidind
on roysched (title_id)