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 > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
