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 of the Information Schema are viewed tables defined in terms
of the base tables of the
Definition Schema. The only purpose of the Definition Schema is to
provide a data model to support
the Information Schema and to assist understanding. An
SQL-implementation need do no more
than simulate the existence of the Definition Schema, as viewed through
the Information Schema
views.
I think it should be possible to create a subset of the standard
information schema in sqlite using virtual tables.
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------