authors table

The authors table contains the names, phone numbers, and other information about authors in the pubs3 database.

authors is defined as follows:

create table authors
(au_id id not null,
au_lname varchar(40) not null,
au_fname varchar(20) not null,
phone char(12) not null,
address varchar(40) null,
city varchar(20) null,
state char(2) null,
country varchar(12) null,
postalcode char(10) null,
unique nonclustered (au_id))

Its nonclustered index for the au_lname and au_fname columns is defined as:

create nonclustered index aunmind
on authors (au_lname, au_fname)

The phone column has the following default:

create default phonedflt as "UNKNOWN"
sp_bindefault phonedft, "authors.phone"

The following view uses authors:

create view titleview
as
select title, au_ord, au_lname,
price, num_sold, pub_id
from authors, titles, titleauthor
where authors.au_id = titleauthor.au_id
and titles.title_id = titleauthor.title_id

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF