How to Retrieve MySQL Tables Ordered by Creation Time in Descending Order

SELECT table_name, create_time
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
ORDER BY create_time DESC;