On 9/30/16, Simon Slavin <[email protected]> wrote: > > On 30 Sep 2016, at 2:13pm, Ertan Küçükoğlu <[email protected]> > wrote: > >> My application is normally working on DatabaseA. I run an attach command >> for >> DatabaseB like: >> Attach DatabaseB as source >> >> After a successful attach. If I want to select something from >> DatabaseB-Table3 is it enough to call below SQL? >> Select * from Table3 >> >> Or, even if there is no table names that overlap on each other, Do I still >> need to run something as follows: >> Select * from source.Table3 > > Use the second one: "source.Table3". It may be possible that the first one > works but it is not documented and may stop working in later versions of > SQLite.
The second one will always work. The problem is, what if the schema for the first database changes and a new Table3 is added there. You may want to do "source.Table3" just to future-proof your application. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
