ADD vs. ADD COLUMN in SQLite?
The COLUMN
keyword is optional. No difference at all.
Try the following script:
CREATE TABLE Test( Col1 INTEGER);INSERT INTO Test (Col1) VALUES (1);ALTER TABLE Test ADD Col2 INTEGER NULL;ALTER TABLE Test ADD COLUMN Col3 INTEGER NULL;SELECT * FROM Test
The result will be:
Col1 Col2 Col31