[Sqlite3]How to get tabe info?
lazarus / 16-Databases

----------------------------------------------------------------------
Borneq · 2020-01-03 12:10

Get all tables (but without system tables):
SELECT * FROM sqlite_master where type='table'
but how to get column names and types of columns?

----------------------------------------------------------------------
Borneq · 2020-01-03 12:58

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i   rc :=
sqlite3_prepare_v2(pDb, 'pragma table_info (sqlite_master)', -1,
@stmt, nil);  if rc=SQLITE_OK then  begin    //will continue to go
down the rows (columns in your table) till there are no more    while
sqlite3_step(stmt) = SQLITE_ROW do    begin       
writeln(sqlite3_column_text(stmt, 1));       
writeln(sqlite3_column_text(stmt, 2));        //do something with
colName because it contains the column's name    end;  end; after
https://stackoverflow.com/questions/947215/how-to-get-a-list-of-
column-names-on-sqlite3-database