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?
their name starts with “sqlite_”
assuming you are using SQLite as the database of course…
I will be using SQLite, MS SQL Server, MySQL, Microsoft Access and PostgreSQL.
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)
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.