On Mar 10, 2010, at 1:44 AM, DbSchema Support wrote: > Hello, > > Here is Roberto from DbSchema. > Is it possible with Sqlite to add constraints using ALTER TABLE ... ? > This would be required since not allways the Foreign keys are > specified when creating the table. > I'm looking forward for an reply, >
No. The ALTER TABLE command in SQLite only supports ALTER TABLE ... ADD COLUMN ... and ALTER TABLE ... RENAME .... For any other changes, you'll need to (1) rename the original table, (2) create a new table in the desired form, (3) copy the content of the original table into the new table, and (4) drop the original table. > Best regards, > Roberto Luca > -- http://www.dbschema.com D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
