Re: Find schema of a table in a query
Dominique Devienne <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAFCRh-9xNiP6xsBnyL+N9n6c-HRRfvMzs-CasR4jMdT5AC-FVA@mail.gmail.com> |
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