[odb-users] How to retrieve schema name ?

[Per Edin]

Hi David!

Maybe I have misunderstood your problem, but wouldn't a simple

SELECT name FROM schema_version GROUP BY name

work? To get all unique schema names in any database.

/Per

On Thu, Mar 19, 2015 at 10:55 AM, David Sarrut
<David.Sarrut at creatis.insa-lyon.fr> wrote:
> Hello,
>
> when create a db with a schema name, there is an additional table
> "schema_version" that is created. When reading a database, say from a file
> with sqlite, is there a way to access this table content and retrieve the
> value for the name ?
>
> thanks,
> David
>
> --
> David Sarrut, Phd
> Directeur de recherche CNRS
> CREATIS, UMR CNRS 5220, Inserm U 1044
> Centre de lutte contre le cancer Léon Bérard
> 28 rue Laënnec, 69373 Lyon cedex 08
> Tel : 04 78 78 51 51 / 06 74 72 05 42
> http://www.creatis.insa-lyon.fr/~dsarrut
> _________________________________
>  "2 + 2 = 5,  for extremely large values of 2"
> _________________________________