Hello, I noticed a small discrepancy between the information returned by the JDBC driver and the names stored in the table sqlite_master.
The driver seems to always return the table and view names in uppercase regardless on how they are stored in sqlite_master: CREATE VIEW v_test AS SELECT * FROM test_table; will store the table in lowercase in sqlite_master (at least when executed through JDBC, haven't tried other ways) DatabaseMetaData.getTables() will return the name of the view as V_TEST. If this value is then used to retrieve the view definition from sqlite_master, no rows are found: SELECT sql FROM sqlite_master where tbl_name = 'V_TEST' Regards Thomas --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
