sqlite - SQLite 中是否有 PRAGMA table_info ('mytable' ) 的等效 SELECT 语句？

Question

在 SQLite 中是否有 PRAGMA table_info('mytable') 的等效 SELECT 语句？本质上，我想获得与 PRAGMA 返回完全相同的结果集:cid、name、type、notnull、dflt_value 和 pk。虽然我知道通过 C 函数 sqlite3_table_column_metadata 获取此信息的其他替代方法，但我更愿意使用 SELECT 语句。

Answer 1

根据doc

PRAGMAs that return results and that have no side-effects can be accessed from ordinary SELECT statements as table-valued functions. For each participating PRAGMA, the corresponding table-valued function has the same name as the PRAGMA with a 7-character "pragma_" prefix. The PRAGMA argument and schema, if any, are passed as arguments to the table-valued function.

For example, information about the columns in an index can be read using the index_info pragma as follows:

PRAGMA index_info('idx52'); Or, the same content can be read using:

SELECT * FROM pragma_index_info('idx52');

这不应该解决问题吗？