Re: Generic way of fetching a list of databases

2018-11-16 Thread Darren Duncan
What you seek is not possible, in any general sense. The concept of "what is a database" varies too greatly between different DBMS products, even if you restrict yourself to SQL DBMSs. Loosely the question is like asking for a "list of websites". If what you want is to have a product or

RE: Generic way of fetching a list of databases

2018-11-16 Thread Fennell, Brian
Closest thing that I know of is INFORMATION_SCHEMA and the INFORMATION_SCHEMA.TABLES pseudo table. INFORMATION_SCHEMA is a standard across many databases. One Database that doesn’t comply is Oracle (but it can be installed by the DBA as an Add-on) for Oracle select from ALL_TABLES (or

Re: Generic way of fetching a list of databases

2018-11-16 Thread Scott Webster Wood via dbi-users
convert to 'rest'ful JSON? Barack-O-phobia: The fear of politicians who think (more) government is the solution to every problem. On Thursday, November 15, 2018, 9:09:44 PM EST, Daniel Kasak wrote: Hi all. I have a project that has to support pretty much every major database

Re: Generic way of fetching a list of databases

2018-11-16 Thread pali
On Friday 16 November 2018 13:09:21 Daniel Kasak wrote: > Hi all. > > I have a project that has to support pretty much every major database > around, plus a number of more esoteric "big data" platforms as well. Until > now, I've had a bunch of methods, implementing fetching databases, schemas, >