Detect last table created in sqlite?

Is this what you are looking for?

SELECT name FROM sqlite_master 
WHERE type ='table' AND name NOT LIKE 'sqlite_%' 
ORDER BY rowid DESC 
LIMIT 1;
2 Likes