| Column_name | 数据类型 | 可为空 | 默认值 | 检查 | 键/索引 |
|---|---|---|---|---|---|
| pub_id | char(4) | 否 | 是1 | 聚集主键 | |
| pub_name | varchar(40) | 是 | |||
| city | varchar(20) | 是 | |||
| state | char(2) | 是 | |||
| country | varchar(30) | 是 | 'USA' |
1 pub_id CHECK 约束定义为 (pub_id = '1756' OR (pub_id = '1622'
OR (pub_id = '0877'
OR (pub_id = '0736' OR (pub_id = '1389')))) OR (pub_id LIKE '99[0-9][0-0]')。
下表显示 publishers 表的内容。
| pub_id | pub_name | city | state | country |
|---|---|---|---|---|
| 0736 | New Moon Books | Boston | MA | USA |
| 0877 | Binnet & Hardley | Washington | DC | USA |
| 1389 | Algodata Infosystems | Berkeley | CA | USA |
| 1622 | Five Lakes Publishing | Chicago | IL | USA |
| 1756 | Ramona Publishers | Dallas | TX | USA |
| 9901 | GGG&G | München | NULL | Germany |
| 9952 | Scootney Books | New York | NY | USA |
| 9999 | Lucerne Publishing | Paris | NULL | France |