INFORMATION SCHEMA (also referred as system catalog) gives you access to database metadata and MySQL server information like the name of a database or table, the data type of a column, and access privileges.
We’ll look at how to get the last modified date of the table.
–Here’s the query to get the last modified of the table from a specific database.
SELECT TABLE_SCHEMA,TABLE_NAME,UPDATE_TIME
FROM information_schema.tables
WHERE TABLE_SCHEMA = ‘TestDB’
ORDER BY UPDATE_TIME DESC;
Happy learning!!
Big Data and SQL 