469,935 Members | 1,792 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

Database last modified

Can someone help me with a query to get the date/time that a database was
last modified?

I looked at the SHOW command but there was no mention of this.

TIA,
Shawn
Jul 20 '05 #1
2 6217

"Shawn McKenzie" <no****@mckenzies.net> wrote in message news:V4*****************@fe1.texas.rr.com...
Can someone help me with a query to get the date/time that a database was
last modified?

I looked at the SHOW command but there was no mention of this.

TIA,
Shawn



try:
Show Table Status from <db-name>

hth,
Mark
Jul 20 '05 #2
"Shawn McKenzie" <no****@mckenzies.net> wrote in message news:<V4*****************@fe1.texas.rr.com>...
Can someone help me with a query to get the date/time that a database was
last modified?

I looked at the SHOW command but there was no mention of this.

TIA,
Shawn


Perhaps the Show table status from 'db_name'. It returns the status of
each table in the given database, with created and modified dates for
each table. Please let me know if you find the way to do it, i am
interested as well.
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Shawn McKenzie | last post: by
15 posts views Thread by DesignGuy | last post: by
11 posts views Thread by Dennis Marks | last post: by
7 posts views Thread by laredotornado | last post: by
2 posts views Thread by bwana.mpoa | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.