W3C home > Mailing lists > Public > whatwg@whatwg.org > October 2007

[whatwg] SQL API + access to tables

From: Scott Hess <shess@google.com>
Date: Fri, 19 Oct 2007 20:08:17 -0700
Message-ID: <696e4b7c0710192008q25c3c250v74d8d57d562087@mail.gmail.com>
On 10/19/07, Brady Eidson <beidson at apple.com> wrote:
> There is no standard way in SQL that I know of to get the list of
> tables in a database.
>
> In SQLite you can enumerate tables out of sqlite_master, but that
> should not be encouraged.
>
> What are people's thoughts about adding this to the API?

This seems way beyond where this spec should go.  If SQLite doesn't
have a way to enumerate tables which can be encouraged, a way should
be added to SQLite (I've considered building some introspection
virtual tables for this kind of thing).

-scott
Received on Friday, 19 October 2007 20:08:17 UTC

This archive was generated by hypermail 2.3.1 : Monday, 13 April 2015 23:08:37 UTC