SqliteColumnNameAndTypeList — Return the names and types of the columns of some table.
A list of two-element lists. The first element is the name of the column and the second is the type.
TableName | Name of the table to get the column name and types from. |
Check
About Configuration for Database Use for info about how to set up Gen for using database-related commands.
For information regarding exceptions / errors, see
here.
% RunSqlCreate my_table {id {integer primary key} desc text notes text}
% QQ [SqlInsertStatement my_table {desc 'one' notes 'uno'}]
% SqliteColumnNameAndTypeList my_table
id {integer primary key} desc text notes text