Re: Find schema of a table in a query

> select name from pragma_database_list d
> where (select name from pragma_table_info(?1) where schema==d.name)
> order by seq!=1, seq limit 1;

Is this possible in sql?

Given a variable ?1 which contains a valid attached DB name is it possible to retrieve the contents of

?1.table_name  ??????

It’s not like ‘select ?1 as DB,* from ?1.table_name’ is valid sql. Am I just being flummoxed by the fact the top works because it’s metadata?

_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users