Re: Find schema of a table in a query

x <[email protected]>
Newsgroups gmane.comp.db.sqlite.general
Message-ID <DB7PR04MB52891AA76E28CD8641C86A97B7320@DB7PR04MB5289.eurprd04.prod.outlook.com>
Thanks Simon.

________________________________
From: sqlite-users <[email protected]> on behalf of Simon Slavin <[email protected]>
Sent: Monday, January 20, 2020 4:49:04 PM
To: SQLite mailing list <[email protected]>
Subject: Re: [sqlite] Find schema of a table in a query

On 20 Jan 2020, at 2:53pm, x <[email protected]> wrote:

> Is this possible in sql?

In SQL schema names and table names are entities.  You cannot bind a parameter to a either of them.

This is why, instead of keeping data in many different databases, you make one big schema, and use that value as a column.
_______________________________________________
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.