Re: Find schema of a table in a query

x <[email protected]>
Newsgroups gmane.comp.db.sqlite.general
Message-ID <DB7PR04MB5289E33F2107AE1510A77335B7330@DB7PR04MB5289.eurprd04.prod.outlook.com>
If I could answer the “such as” I wouldn’t have asked the question. The word “hoping” is the clue as in I was hoping there was some function I had overlooked. I’ve settled for using the sqlite3_table_column_metadata function in a loop using each db name in turn in the order sqlite3 does.



________________________________
From: sqlite-users <[email protected]> on behalf of Warren Young <[email protected]>
Sent: Sunday, January 19, 2020 4:02:40 PM
To: SQLite mailing list <[email protected]>
Subject: Re: [sqlite] Find schema of a table in a query

On Jan 19, 2020, at 2:41 AM, x <[email protected]> wrote:
>
> I was hoping for something simpler.

Such as?

I mean, your question basically reduces to “I need to be inside the parse loop,” and SQLite has come along and said, “Hey, check this out, you can be inside the parse loop.”  I mean, how cool is that?
_______________________________________________
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.