[whatwg] SQL API + access to tables

Scott Hess shess at google.com
Fri Oct 19 20:08:17 PDT 2007


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



More information about the whatwg mailing list