sqlite3更改字段名

这里有段代码，将TBAcct.CName改为Name

ALTER TABLE TBAcct RENAME TO TBAcctOld;
CREATE TABLE TBAcct(ID INTEGER PRIMARY KEY AUTOINCREMENT, Name VARCHAR(50));
INSERT INTO TBAcct SELECT ID, CName FROM TBAcctOld;
DROP TABLE TBAcctOld;