Re: [sqlite] View - What happens internally

2009-03-02 Thread Lloyd
Thank you Igor and Dan. Now I am clear about the concept. On Sat, 28 Feb 2009 20:07:45 +0530, Dan danielk1...@gmail.com wrote: On Feb 28, 2009, at 8:44 PM, Lloyd wrote: Hi, When we create a view what happens internally in sqlite? Does it select all the data from the table and then

Re: [sqlite] View - What happens internally

2009-02-28 Thread Dan
On Feb 28, 2009, at 8:44 PM, Lloyd wrote: Hi, When we create a view what happens internally in sqlite? Does it select all the data from the table and then insert it in to the view? or would the records in the view keep references to records in main table? just to know whether