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

[Felix Schwarz]

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 ROWID from some_old_table... to some_new_table? Or will  
it create new ROWIDs for some_new_table?

(In this example some_new_table shall be an empty, freshly created  
table.)

And is the answer to above question also true for INSERT-SELECT-pairs  
across two attached database files?

Thanks in advance!

Felix