[whatwg] SQL API + access to tables

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