Bug 65766 - UI: Wish: More details for tables (meta tags/properties displayed)
Summary: UI: Wish: More details for tables (meta tags/properties displayed)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: Other Linux (All)
: lowest enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
Reported: 2013-06-14 20:05 UTC by Mike A. Fargo
Modified: 2017-11-06 00:12 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Mike A. Fargo 2013-06-14 20:05:26 UTC
Problem description: 

Currently, the main window parts in four sections (or rather 5): 

0. Database   |1.Tasks        | 2. Description
   Tables     |_______________________________
   Queries    |3.Tables       | 4. none/document

This is about the 4th section, by default set to
"none" (no further lable), but changable to "document"
(rather content? - retranslated from German).

Expected behavior:
I'd like to utter my wish to add further views on tables,
namely "properties", which could present some core information
(amount of data rows, size, last change, date of creation ...).

As I tend to forget names of tables, I'd even prefer, to have
access/change dates displayed directly in 3. next to each
table name.

Any chance to get parts of this implemented, one day?

Operating System: Debian
Version: release
Comment 1 Joel Madero 2013-06-20 20:38:10 UTC
@Lionel - seems reasonable to me but want to make sure it's a valid request.
Comment 2 Lionel Elie Mamane 2013-06-20 21:09:10 UTC
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).
Comment 3 Alex Thurgood 2015-01-03 17:38:03 UTC Comment hidden (no-value)