Re: Find schema of a table in a query

Thanks Dominique. I was aware of that route but I was hoping for something simpler.



________________________________
From: sqlite-users <[email protected]> on behalf of Dominique Devienne <[email protected]>
Sent: Sunday, January 19, 2020 9:32:28 AM
To: SQLite mailing list <[email protected]>
Subject: Re: [sqlite] Find schema of a table in a query

On Sun, Jan 19, 2020 at 9:47 AM x <[email protected]> wrote:

> Suppose you’re given a query ‘SELECT 1 from tbl’ by a user and you want to
> know the name of the schema that tbl belongs to. What’s the easiest way to
> do this?


Set an authorizer. Requires to write code though, cannot be done in SQL.
https://www.sqlite.org/c3ref/set_authorizer.html
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users