Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

Information_schema on sqlite



  • Hello.
    I know how to get table names from SQLite database:
    @QSqlQuery query("SELECT name FROM sqlite_master WHERE type = 'table'");@

    Can you tell me, how to make a query for: column_name, data_type, is_nullable, ... ?



  • @
    QSqlQuery query("PRAGMA table_info(" + tableName +")");
    @


Log in to reply