Jump to content


Photo

SQL Table Creation Date


  • Please log in to reply
1 reply to this topic

#1 CanMan2004

CanMan2004
  • Members
  • PipPipPip
  • Advanced Member
  • 254 posts

Posted 08 August 2006 - 05:05 PM

Hi all

Is there anyway to print on screen the date a sql table was created?

Thanks in advance

Ed

#2 GingerRobot

GingerRobot
  • Staff Alumni
  • Advanced Member
  • 4,086 posts
  • LocationUK

Posted 08 August 2006 - 05:46 PM

Looking at phpMyAdmin, there is a database called information_schema with a table called tables. This seems to contain all the tables i have created with their creation date. I see no reason why you couln't select this database and retrieve this information.

I guess your ability to do this would depend on your access. I would think that if you are not logged in as root then you probably wont be able to access this. I could be wrong though.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users