| Subject | Re: [firebird-support] Modified date of Tables or Stored Procedure. |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2011-10-31T08:22:29Z |
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
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