SQLite 中的系统表列表 [英] List of system tables in SQLite

问题描述

我正在尝试根据它们是系统表还是用户生成的表来过滤 SQLite 数据库中的所有表.

I am trying to filter all the tables in a SQLite database based on if they are system tables or user generated ones.

到目前为止，我发现它们是带有 sqlite_ 前缀和 AllDataTypes 的那些.

So far I've found out that they are the ones with the sqlite_ prefix and AllDataTypes.

有人做过这样的事情吗?有他们的名单吗?

Has anyone done something like this? Is there a list of them?

提前致谢.

推荐答案

只有一个系统表有任何影响.

There is only one system table that is of any consequence.

select * from sqlite_master

但是你可能会从sqlite_sequence那里得到一些有用的信息，

but you may get some useful information from sqlite_sequence,

这篇关于SQLite 中的系统表列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！