Jump to content

Archived

This topic is now archived and is closed to further replies.

CanMan2004

SQL Table Creation Date

Recommended Posts

Hi all

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

Thanks in advance

Ed

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.