https://bugs.freedesktop.org/show_bug.cgi?id=65766
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Severity|normal |enhancement Priority|medium |lowest Ever confirmed|0 |1 --- Comment #2 from Lionel Elie Mamane <[email protected]> --- I understand the legitimacy of the wish. If someone feels like implementing it, I take patches. Stuff we can IMHO reasonably achieve show there: Number of rows: get it from "SELECT COUNT(*) FROM tblName" or XDatabaseMetadata::getIndexInfo (from the row with TYPE=tableIndexStatistic) Structure of table and its indices: columns, column size, type, ...: XDatabaseMetadata::getColumns and XDatabaseMetadata::getIndexInfo Table privileges: XDatabaseMetadata::getTablePrivileges Stuff that is far more difficult: creation date, byte size of the table, date of last change, ... The reason is that AFAIK there is no well-established API for getting this information. I expect many database systems don't even track / store / remember the creation date or date of last change. Theoretically, we could add a new SDBC interface to give this kind of information, but then we have to implement for each SDBC driver, which is not that bad, but the worse is that it will "never" work / be available for access through ODBC nor JDBC, since neither ODBC nor JDBC have an API call to get this information. And obviously it will only work for DBMS that actually track these informations, and expose some kind of way to get the information (e.g. a system-specific SQL query). -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
