Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

authors Table

The authors table describes writers associated with the three publishing lines in bookbiz. There are 23 authors. Four columns (au_id, phone, state, zip) are fixed-length character datatype. The other columns are all variable-length character datatype. There is a unique index on au_id and another index (nonunique) on the author last and first name.

						au_id       au_lname       au_fname    phone        address              city          
 state zip
not null    not null       not null    null         null                 null          
 null  null
auidind
						aunmind =========== ============== =========== ============ ==================== ...