On 1/28/17, David Niklas <[email protected]> wrote: > > # ALTER TABLE processors ADD CONSTRAINT bit NOT NULL > Error: near "CONSTRAINT": syntax error > > # ALTER TABLE processors DROP bit; > Error: near "DROP": syntax error
ALTER TABLE is one of the few areas where SQLite's SQL support is thin. SQLite only supports ALTER TABLE ADD COLUMN and ALTER TABLE RENAME TABLE. > > I expected that both of the above would add the constraint. > > # SELECT boards.*,processors.*,storage.emmc FROM processors INNER >> JOIN storage ON processors.board = storage.board; > Error: no such table: boards > All tables used by the query must be named in the FROM clause. What database engine are you used to that does not require this? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
