sqlite3_query_table(3f) - [M_sqlite] Retrieve the column names and types from a table
Synopsis
Description
Options
subroutine sqlite3_query_table(db, tablename, columns)
type(SQLITE_DATABASE) db character(len=*) tablename type(SQLITE_COLUMN), dimension(:), pointer columns
Query the structure of the tableSide effects:
The columns array is allocated and filledNote:
On entry the columns argument must not be associated. On exit, it will point to a freshly allocated array of column names/types
db Structure variable identifying the database connection tablename Name of the table to be inspected columns An array with the properties of all columns. Deallocate it when you are done.
Nemo Release 3.1 | sqlite3_query_table (3) | February 23, 2025 |