Db info table

Question

I want to create a ' master' db that should have only one table. This table contains the fields:

|DBname|DBowner|Task|created|updated|

Information about DBname, DBownerand the created field should be automatically filled in (this information can be used from the database settings).

I want this table for history and for review. I also searched for something similar, but found nothing. Can anyone get me for this?

Answer 1

If you use mysql, you can try using the built-in schema table, for example: select TABLE_SCHEMA, TABLE_NAME, CREATE_TIME, UPDATE_TIME from information_schema.tables