-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 25/01/13 12:57, Petite Abeille wrote:
> and lower( sql ) like '% virtual %'
It is worth pointing out that SQLite normalises the create table text for
a table in the sqlite_master table. ie it always begins "CREATE VIRTUAL
TABLE"
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?
selectname
from sqlite_master
where type = 'table'
and lower( sql ) like '% virtual %'
order by
2 matches
Mail list logo