Re: [firebird-support] Create Date of Database Object

[Virna Constantin costel...@yahoo.com [firebird-support]]

On Monday, August 4, 2014 2:06 PM, "Svein Erling Tysvær 
svein.erling.tysv...@kreftregisteret.no [firebird-support]" 
<firebird-support@yahoogroups.com> wrote:
 


>>Hi,
>> 
>>Is it possible to see from the systems tables when a database object was 
>>created?
>> 
>>For instance I want to try and find out when a specific trigger was created 
>>on the database, is this possible?
>
>table: MON$DATABASE
>field: MON$CREATION_DATE

I think that is just the creation date (or "restore date" if restored) of the 
database, if there had been a creation date of the trigger, I would have 
expected that to be in the RDB$TRIGGERS table. However, I don't think there is 
such a field, and that it is more a matter of implementing a company policy to 
store the creation date of triggers in the trigger itself or it's description. 
I doubt there is a way to find out when a trigger was created if whomever wrote 
the trigger didn't do this, but I hope I'm wrong.

Set





Sorry, I misunderstood the question. 
Hint, it will create a table that will contain the list of objects in the 
database and the date on which they are inserted. The event ON CONNECT or ON 
DISCONNECT will make a comparison between the table and the table RDB$RELATIONS 
my differences are added to the table but with the date change was found.

(google translation)