Hello,

What would be a reasonable way to programmatically identify all the virtual 
tables in a database?

Is there a structured way to do so?

Short of scanning the DDLs that is?

select    name
from      sqlite_master

where     type = 'table'
and       lower( sql ) like '% virtual %'

order by  name;

Thanks in advance.

Cheers,

PA.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to