On Sun, Jul 16, 2017 at 12:25 PM, Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:
> If there is a built in function for getting the schema of the particular
> database, I would use that. For instance you can query sqLite master
> database for a list of tables using:
>
That's
If there is a built in function for getting the schema of the particular
database, I would use that. For instance you can query sqLite master database
for a list of tables using:
SELECT * FROM my_db.sqlite_master
mySQL can be queried using SHOW TABLES
Googling this indicates that for postgres
On 07/14/2017 03:48 PM, Dr. Hawkins via use-livecode wrote:
Sometime ago, I wrote my own getTableNames() because
revDatabaseTableNames() would consistently fail to find them all.
Now, it to is filing.
It is, in essence,
*put* "SELECT table_name FROM information_schema.tables ;" \
& cr into d
Sometime ago, I wrote my own getTableNames() because
revDatabaseTableNames() would consistently fail to find them all.
Now, it to is filing.
It is, in essence,
*put* "SELECT table_name FROM information_schema.tables ;" \
& cr into dcmd
*put* revDataFromQuery(,cr,db,dcmd) into tabList
*return
