On Fri, 19 Oct 2007, Brady Eidson 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?
Dnia 22-10-2007, pon o godzinie 17:09 -0700, Michaeljohn Clement
napisał(a):
> Křištof Želechovski wrote:
> > Also, if we agreed to that, this would be a workaround for a supposed
> > deficiency of SQL. But the SQL committee does not recognize it as a
> > deficiency; otherwise it would have been f
Křištof Želechovski wrote:
> Also, if we agreed to that, this would be a workaround for a supposed
> deficiency of SQL. But the SQL committee does not recognize it as a
> deficiency; otherwise it would have been fixed by now.
No, this is actually fixed for 15 years now. The SQL spec directly
ad
iding
this functionality to Firebug as an extension.
Best regards,
Chris
-Original Message-
From: Leons Petrazickis [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 20, 2007 6:29 PM
To: Křištof Želechovski
Cc: Brady Eidson; WHATWG Mailing List
Subject: Re: [whatwg] SQL API + access to tables
Yo
On 10/19/07, Brady Eidson <[EMAIL PROTECTED]> wrote:
> In fact, we plan to disallow access to the
> sqlite_master table because there's no reason the client *should* be
> able to access such an implementation specific field that has nothing
> to do with "client side database storage"
Not really my
o:[EMAIL PROTECTED] On Behalf Of Brady Eidson
> Sent: Saturday, October 20, 2007 3:14 AM
> To: WHATWG Mailing List
> Subject: [whatwg] SQL API + access to tables
>
> There is no standard way in SQL that I know of to get the list of
> tables in a database.
>
> In SQLite you ca
iling List
Subject: [whatwg] SQL API + access to tables
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?
~Brady
It isn't that useful to get the table list, only for introspection
would you need it. Most users of the API will know the schema of the
database, and know the table names they need. It would be useful if
the SQL back-end did not support CREATE TABLE IF NOT EXISTS. But users
can just blindin
On Oct 19, 2007, at 8:08 PM, Scott Hess wrote:
On 10/19/07, Brady Eidson <[EMAIL PROTECTED]> 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 peo
On 10/19/07, Brady Eidson <[EMAIL PROTECTED]> 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
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?
~Brady
11 matches
Mail list logo
