tableList

Queries a list of all tables and views in the main database schema.

This pragma returns a cursor with the following columns:

• schema: The name of the database schema (e.g., "main").

• name: The name of the table or view.

• type: The type of the object, either "table" or "view".

• ncol: The number of columns in the table or view.

• wr: An integer flag indicating if the table is a WITHOUT ROWID table.

• strict: An integer flag indicating if the table is a STRICT table.

This is useful for dynamically discovering the tables and views present in the database. It does not list system tables (those starting with "sqlite_").

See also