tableXInfo

Retrieves extended information about the columns of a specific table, including hidden columns.

This pragma is an enhanced version of tableInfo. It provides the same information but also includes rows for hidden columns that are generated for features like WITHOUT ROWID tables or virtual tables.

The returned cursor contains the following columns for each column (including hidden ones):

• cid: The column ID.

• name: The name of the column.

• type: The declared data type.

• notnull: A boolean flag (1 or 0) for the NOT NULL constraint.

• dflt_value: The default value for the column.

• pk: An integer indicating if the column is part of the primary key.

• hidden: A flag indicating the column's status:

• 0: A standard, visible column.

• 1: A hidden column used for internal purposes (e.g., virtual tables).

• 2: A hidden column that is part of a WITHOUT ROWID primary key.

This is useful for deep schema introspection, especially when working with advanced table features.

Parameters

See also