Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get list of changes to the tables/structure 1

Status
Not open for further replies.
Mar 23, 2006
3
US
How can I generated a report which shows list of changes to the tables/structure.
the generate should also tell me the date/time stamp of changes implemented.

thanks!
 
I am looking for a method (command, report, table) to generate determine the date/time stamp of changes implemented . Any help would be greatly appreciated. Thank you.
 
This kind of history data is not stored in any part of the metadata. The current info can be pulled from the SQL below:

select tabname ||' '|| created
from systables
where tabid>99 ;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top