Mysql, How do we check database or Schema properties

I have created a database, is there anyway we can check this database properties? something like when was the db created and few other thing?
motioneyeAsked:
Who is Participating?
 
UmeshMySQL Principle Technical Support EngineerCommented:
>>I have created a database, is there anyway we can check this database properties? something like when was the db created and few other thing?

What database properties.. ??? table it contains

SHOW TABLES FROM db_name;

Create database syntax

SHOW CREATE DATABASE db_name;

>>something like when was the db created and few other thing?

I'm afraid to say there is no SHOW DATABASE STATUS command exists to check database creation date or related details( last modified etc).. but you can check this kind of info for table using SHOW TABLE STATUS etc

This is all about SQL commands... but from OS level I guess you can check.. when the folder ( created on DB NAME) was created/modified etc


What else details you are looking for database? pls let me know
0
 
motioneyeAuthor Commented:
Yes there is none in database level to check on properties but it was exist as table level
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.