[firebird-support] Modified date of Tables or Stored Procedure.

[Mahesh Pratihari]

Hi All,

 

How to Identify the Modified and Created Date of Tables or Stored
Procedure in Firebird.

 

Expecting early reply on this.

 

Thanks,

Mahesh Pratihari

Sonata Software Limited 

Phone   : +91 80 3097 1570

Mobile  : +91 99808 37446

www.sonata-software.com

 

Please don't print this email unless you really need to. This will
preserve trees on our planet.

 



[Non-text portions of this message have been removed]

Re: [firebird-support] Modified date of Tables or Stored Procedure.

[Dmitry Kuzmenko]

Hello, Mahesh!

Monday, October 31, 2011, 12:02:24 PM, you wrote:

MP How to Identify the Modified and Created Date of Tables or Stored
MP Procedure in Firebird.

this information is not stored in db anywhere.

MP Expecting early reply on this.

you could look by yourself into rdb$procedures, rdb$triggers,
rdb$relations, etc. no timestamp fields at all.

Some tools for developers allows to store that information
in their tables, and, moreover, store version info and other
log data allowing to track who and when created/modified DB objects.

Check functionality of tool that you use. If you work just with isql,
decide to use such tool I've mentioned.

-- 
Dmitry Kuzmenko, www.ib-aid.com