Re: [sqlite] What happens with ROWID when doing a "INSERT INTO somenewdb SELECT * FROM someolddb"

Felix Schwarz wrote: I have found the possibility of using CREATE TABLE some_new_table INSERT INTO some_new_table SELECT * FROM some_old_table_with_same_layout; to be extremely useful to recreate databases. Since ROWID is a hidden field of every table: will sqlite copy over

[sqlite] What happens with ROWID when doing a "INSERT INTO somenewdb SELECT * FROM someolddb"

Hi, I have found the possibility of using CREATE TABLE some_new_table INSERT INTO some_new_table SELECT * FROM some_old_table_with_same_layout; to be extremely useful to recreate databases. Since ROWID is a hidden field of every table: will sqlite copy over the identical ROW