# Detect last table created in sqlite?

**URL:** <https://forum.xojo.com/t/detect-last-table-created-in-sqlite/79985>\
**Category:** Web\
**Created:** [April 16, 2024, 12:17pm UTC](https://forum.xojo.com/t/detect-last-table-created-in-sqlite/79985 "2024-04-16T12:17:47Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Underwriters\_Technologies](https://forum.xojo.com/letter_avatar_proxy/v4/letter/u/ed655f/32.png) [@Underwriters\_Technologies](https://forum.xojo.com/u/Underwriters_Technologies)\
**Post date:** [April 16, 2024, 10:37pm UTC](https://forum.xojo.com/t/detect-last-table-created-in-sqlite/79985/4 "2024-04-16T22:37:48Z")

</div>

Is this what you are looking for?

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

```

---

_[View the full topic](https://forum.xojo.com/t/detect-last-table-created-in-sqlite/79985)._