### Create an Addressbook
CREATE TABLE Addressbook
(regist_no INTEGER NOT NULL,
name VARCHAR(128) NOT NULL,
address VARCHAR(256) NOT NULL,
tel_no CHAR(10),
mail_address CHAR(20),
PRIMARY KEY (regist_no));
### Add another postal column
ALTER TABLE Addressbook ADD COLUMN postal_code CHAR(8) NOT NULL;
#### Drop the table
DROP TABLE Addressbook;
一旦删除了table, 是无法恢复的,只能重建。