Kishor, I think Marco may want to be able to know how to determine which tables in a DB are real tables and which ones below to virtual tables. If you want to do something like dump tables from the database, you do not want to be dumping all the internally generated real tables. It might be nice if there were some way to identify if a given table was:
1) a normal table 2) a virtual table 3) a child of a virtual table But I'm only guess that this might be what Marco wants? Marco? -Steve P Kishor wrote: > On 9/13/08, Marco Bambini <[EMAIL PROTECTED]> wrote: >> Yes but creating a virtual tables involves the creations of other >> related tables ... > > Well, the FTSn mechanism does all the extra table voodoo for you, so > you don't have to be bothered about it. From what it seems like, the > other magic tables are not virtual tables. In any case, we are not > advised to mess with them unless we have security clearance. > >> does all the virtual table implementations (fts1, >> fts2, fts3) follow the same schema or it is implementation dependent? > > Probably there is some difference from FTS1..3, but I have no > recollection of 2, and I never implemented 1. > > In any case, the table that is VIRTUAL is the one that you create > yourself. And, per your original question of how to identify it, well, > it says so in the schema. There might be a PRAGMA command for it as > well, but nothing could be clearer than the word VIRTUAL right there > in the schema. > > >> >> --- >> Marco Bambini >> http://www.sqlabs.net >> http://www.sqlabs.net/blog/ >> http://www.sqlabs.net/realsqlserver/ >> >> >> >> >> On Sep 13, 2008, at 4:02 PM, P Kishor wrote: >> >> > On 9/13/08, Marco Bambini <[EMAIL PROTECTED]> wrote: >> >> What is the best way to identify virtual tables inside a sqlite >> >> database? >> > >> > >> > isn't the schema enough? In my world it says >> > >> > CREATE VIRTUAL TABLE ... >> > >> >> >> >> Thanks a lot. >> >> --- >> >> Marco Bambini >> >> http://www.sqlabs.net >> >> http://www.sqlabs.net/blog/ >> >> http://www.sqlabs.net/realsqlserver/ >> >> >> >>> _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
