# System Tables

**URL:** <https://forum.xojo.com/t/system-tables/37878>\
**Category:** Databases\
**Created:** [May 28, 2017, 7:49pm UTC](https://forum.xojo.com/t/system-tables/37878 "2017-05-28T19:49:08Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bryan\_Dodson](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/ba8739/32.png) [@Bryan\_Dodson](https://forum.xojo.com/u/Bryan_Dodson)\
**Post date:** [May 28, 2017, 7:49pm UTC](https://forum.xojo.com/t/system-tables/37878/1 "2017-05-28T19:49:08Z")

</div>

How can i identify system tables? I want to create a list of tables that the user can select, but I do not want to list the system tables. TableSchema only lists the table names. How can i determine which tables are system tables?

---

<div class="post-metadata">

**Author:** ![Jean-Yves\_Pochez](https://forum.xojo.com/user_avatar/forum.xojo.com/jean-yves_pochez/32/21769_2.png) [@Jean-Yves\_Pochez](https://forum.xojo.com/u/Jean-Yves_Pochez)\
**Post date:** [May 28, 2017, 8:00pm UTC](https://forum.xojo.com/t/system-tables/37878/2 "2017-05-28T20:00:26Z")

</div>

their name starts with “sqlite\_”

---

<div class="post-metadata">

**Author:** ![DaveS](https://forum.xojo.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@DaveS](https://forum.xojo.com/u/DaveS)\
**Post date:** [May 28, 2017, 8:19pm UTC](https://forum.xojo.com/t/system-tables/37878/3 "2017-05-28T20:19:09Z")

</div>

> [@333055:@Jean-Yves Pochez](#):
>
> their name starts with “sqlite\_”

assuming you are using SQLite as the database of course…

---

<div class="post-metadata">

**Author:** ![Bryan\_Dodson](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/ba8739/32.png) [@Bryan\_Dodson](https://forum.xojo.com/u/Bryan_Dodson)\
**Post date:** [May 28, 2017, 8:45pm UTC](https://forum.xojo.com/t/system-tables/37878/4 "2017-05-28T20:45:47Z")

</div>

I will be using SQLite, MS SQL Server, MySQL, Microsoft Access and PostgreSQL.

---

<div class="post-metadata">

**Author:** ![DaveS](https://forum.xojo.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@DaveS](https://forum.xojo.com/u/DaveS)\
**Post date:** [May 28, 2017, 8:58pm UTC](https://forum.xojo.com/t/system-tables/37878/5 "2017-05-28T20:58:03Z")

</div>

Each database engine has its own rules… in some cases you might have to access “system” tables outside of the normal schema (this is the case with Oracle for example)

---

<div class="post-metadata">

**Author:** ![Jean-Yves\_Pochez](https://forum.xojo.com/user_avatar/forum.xojo.com/jean-yves_pochez/32/21769_2.png) [@Jean-Yves\_Pochez](https://forum.xojo.com/u/Jean-Yves_Pochez)\
**Post date:** [May 29, 2017, 5:15am UTC](https://forum.xojo.com/t/system-tables/37878/6 "2017-05-29T05:15:06Z")

</div>

if you want to deal with the structure of all these kind of databases, you will have to parse the tables and fields yourself.  
tableschema and fieldschema will not return all the informations you ay need.

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 6:47pm UTC](https://forum.xojo.com/t/system-tables/37878/7 "2020-10-29T18:47:18Z")

</div>