Jump to content


SQL Table Creation Date

  • Please log in to reply
1 reply to this topic

#1 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


#2 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