[firebird-support] Trying to decide legacy tables.

[Maureen Bertocci mberto...@bblfleet.com [firebird-support]]

Hello,  and thank you I am excite about my new endeavor!


I would like to join the support group.  I am new to firebird.   There are two 
things I am trying to figure out.
1. The first one is How can I print a relationship diagram of all tables in the 
database.
2. How can I tell the last time a table was accessed?


Warm regards,
Maureen Bertocci

Re: [firebird-support] Trying to decide legacy tables.

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On Mon, 10 Aug 2015 19:23:56 +, "Maureen Bertocci
mberto...@bblfleet.com [firebird-support]"
 wrote:
> Hello,  and thank you I am excite about my new endeavor!
> 
> 
> I would like to join the support group.  I am new to firebird.   There
are
> two things I am trying to figure out.
> 1. The first one is How can I print a relationship diagram of all tables
> in the database.

There is nothing in Firebird itself to do this; Firebird is a database
server. You need a tool like Database Workbench or IB Expert to do this.

> 2. How can I tell the last time a table was accessed?

You can't, no such information is tracked. For inserts, updated, and
deletes you can track this using triggers, but you need to set it up
yourself. For selects it's not possible.

Mark