Transact-SQL Reference
authors
| Column_name | Data type | Nullable | Default | Check | Key/index |
|---|---|---|---|---|---|
| au_id | id | no | yes 1 | PK, clust. | |
| au_lname | varchar(40) | no | Composite, nonclust. 3 | ||
| au_fname | varchar(20) | no | Composite, nonclust. 3 | ||
| phone | char(12) | no | 'UNKNOWN' | ||
| address | varchar(40) | yes | |||
| city | varchar(20) | yes | |||
| state | char(2) | yes | |||
| zip | char(5) | yes | yes 2 | ||
| contract | bit | no |
1 The au_id CHECK constraint is defined as (au_id LIKE '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]').
2 The zip CHECK constraint is defined as (zip LIKE '[0-9][0-9][0-9][0-9][0-9]').
3 The composite, nonclustered index is defined on au_lname and au_fname.
These tables show the contents of the authors table. The first column (au_id) is repeated in the second table, along with columns 5 through 9.
| au_id (1) | au_lname (2) | au_fname (3) | phone (4) |
|---|---|---|---|
| 172-32-1176 | White | Johnson | 408 496-7223 |
| 213-46-8915 | Green | Marjorie | 415 986-7020 |
| 238-95-7766 | Carson | Cheryl | 415 548-7723 |
| 267-41-2394 | O'Leary | Michael | 408 286-2428 |
| 274-80-9391 | Straight | Dean | 415 834-2919 |
| 341-22-1782 | Smith | Meander | 913 843-0462 |
| 409-56-7008 | Bennet | Abraham | 415 658-9932 |
| 427-17-2319 | Dull | Ann | 415 836-7128 |
| 472-27-2349 | Gringlesby | Burt | 707 938-6445 |
| 486-29-1786 | Locksley | Charlene | 415 585-4620 |
| 527-72-3246 | Greene | Morningstar | 615 297-2723 |
| 648-92-1872 | Blotchet-Halls | Reginald | 503 745-6402 |
| 672-71-3249 | Yokomoto | Akiko | 415 935-4228 |
| 712-45-1867 | del Castillo | Innes | 615 996-8275 |
| 722-51-5454 | DeFrance | Michel | 219 547-9982 |
| 724-08-9931 | Stringer | Dirk | 415 843-2991 |
| 724-80-9391 | MacFeather | Stearns | 415 354-7128 |
| 756-30-7391 | Karsen | Livia | 415 534-9219 |
| 807-91-6654 | Panteley | Sylvia | 301 946-8853 |
| 846-92-7186 | Hunter | Sheryl | 415 836-7128 |
| 893-72-1158 | McBadden | Heather | 707 448-4982 |
| 899-46-2035 | Ringer | Anne | 801 826-0752 |
| 998-72-3567 | Ringer | Albert | 801 826-0752 |
| au_id (1) | address (5) | city (6) | state (7) | zip (8) | contract (9) |
|---|---|---|---|---|---|
| 172-32-1176 | 10932 Bigge Rd. | Menlo Park | CA | 94025 | 1 |
| 213-46-8915 | 309 63rd St. #411 | Oakland | CA | 94618 | 1 |
| 238-95-7766 | 589 Darwin Ln. | Berkeley | CA | 94705 | 1 |
| 267-41-2394 | 22 Cleveland Av. #14 | San Jose | CA | 95128 | 1 |
| 274-80-9391 | 5420 College Av. | Oakland | CA | 94609 | 1 |
| 341-22-1782 | 10 Mississippi Dr. | Lawrence | KS | 66044 | 0 |
| 409-56-7008 | 6223 Bateman St. | Berkeley | CA | 94705 | 1 |
| 427-17-2319 | 3410 Blonde St. | Palo Alto | CA | 94301 | 1 |
| 472-27-2349 | PO Box 792 | Covelo | CA | 95428 | 1 |
| 486-29-1786 | 18 Broadway Av. | San Francisco | CA | 94130 | 1 |
| 527-72-3246 | 22 Graybar House Rd. | Nashville | TN | 37215 | 0 |
| 648-92-1872 | 55 Hillsdale Bl. | Corvallis | OR | 97330 | 1 |
| 672-71-3249 | 3 Silver Ct. | Walnut Creek | CA | 94595 | 1 |
| 712-45-1867 | 2286 Cram Pl. #86 | Ann Arbor | MI | 48105 | 1 |
| 722-51-5454 | 3 Balding Pl. | Gary | IN | 46403 | 1 |
| 724-08-9931 | 5420 Telegraph Av. | Oakland | CA | 94609 | 0 |
| 724-80-9391 | 44 Upland Hts. | Oakland | CA | 94612 | 1 |
| 756-30-7391 | 5720 McAuley St. | Oakland | CA | 94609 | 1 |
| 807-91-6654 | 1956 Arlington Pl. | Rockville | MD | 20853 | 1 |
| 846-92-7186 | 3410 Blonde St. | Palo Alto | CA | 94301 | 1 |
| 893-72-1158 | 301 Putnam | Vacaville | CA | 95688 | 0 |
| 899-46-2035 | 67 Seventh Av. | Salt Lake City | UT | 84152 | 1 |
| 998-72-3567 | 67 Seventh Av. | Salt Lake City | UT | 84152 | 1 |