>>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
