Hello I don't understand the sqlite command "alter table add column". Please help me!
I have the following 2 tables: TABLEONE(columnA INTEGER PRIMARY KEY, columnB TEXT); TABLETWO(columnX INTEGER PRIMARY KEY, columnY TEXT); I want to add a new column "cloumnZ" to TABLETWO. The new column must be a foreignkey and references to columnA! It is not allowed to delete TABLE TWO!!! How is the correct Sqlite Alter Table command? Thanks! _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
