Matt Young wrote:
> I have table1, I make a view view one of that table. I then delete the
> table, the view does not work.
> I then recreate the table, and alter its name to the one viewed.
> and view suddenly works.
> Am I dreaming? Does SQLite3 maintain a schema in views an allow us to
> alter table names?
A view is nothing more than a stored SELECT statement. Basically, when you
prepare a statement like
select * from ViewName;
it is rewritten as
select * from (select * from UnderlyingTable);
and then the result of such rewriting is parsed and processed as usual.
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users