Thanks Dennis, I appreciate the detailed response.
Sam
---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-Original
Samuel R. Neff wrote:
Dennis,
Do any database systems actually implement this part of the standard? MSSQL
used the term information schema in their MSSQL 2000 version of metadata
access but afaik it was not close to the ANSI standard at all. It's a been
a while for me but I think the Oracle
Dennis Cote schrieb:
I think it should be possible to create a subset of the standard
information schema in sqlite using virtual tables.
That would be very nice and consistent !
Marten
-
To unsubscribe, send
Igor Tandetnik wrote:
I don't believe there is a standardized way to access metadata.
Igor,
The SQL:1999 and later standards define a standardized Definition Schema
and Information Schema to allow users to get the meta information from a
database.
From the SQL:1999 standard:
The views
Stef Mientki <[EMAIL PROTECTED]> wrote:
PRAGMA table_info(table-name);
And it also works for views, as just found out by trial and error ;-)
Is this standard SQL behavior ?
PRAGMA statement is not part of standard SQL. I don't believe there is a
standardized way to access metadata. Every
5 matches
Mail list logo