SELECT
TABLE_SCHEMA,
TABLE_NAME,
UPDATE_TIME
FROM information_schema.tables
WHERE TABLE_SCHEMA = '{{ database_name }}'
ORDER BY UPDATE_TIME DESC;
-
TABLE_SCHEMAデータベースの事
Reference
ベースの SQL を見つけた場所
https://stackoverflow.com/a/307488
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme