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)
