-- 3.1 表1-A 表 Addressbook (地址簿)中的列
create table Addressbook(
regist_no integer not null,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
ail_address char(20),
primary key(regist_no)
);
-- 3.2 添加如下一列 postal_code (邮政编码
alter table Addressbook add column postal_code char(8) not null;
-- 3.3
drop table addressbook;
-- 3.4
create table Addressbook(
regist_no integer not null,
name varchar(128) not null,
address varchar(256) not null,
tel_no char(10),
ail_address char(20),
postal_code char(8) not null,
primary key(regist_no)
);
insert into addressbook values();
insert into addressbook values();
insert into addressbook values();
insert into addressbook values(),(),();