SQLite权威指南-CLP(command line program) [ 3 ]：改变资料表的SQL语法介绍
资料来源：SQLite权威指南 P021～P022
CREATE TABLE contacts ( id INTEGER PRIMARY KEY,name TEXT NOT NULL COLLATE NOCASE,phone TEXT NOT NULL DEFAULT ‘UNKNOWN’,UNIQUE (name,phone) );
定义：ALTER TABLE table { RENAME TO name | ADD COLUMN column_def }
ALTER TABLE contacts
ADD COLUMN email TEXT NOT NULL DEFAULT ” COLLATE NOCASE;
.schema contacts
