Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Information_schema on sqlite

3rd Party Software

2 Posts 2 Posters 4.3k Views 1 Watching

T Offline
T Offline
Tangent

wrote on last edited by

#1

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, ... ?
1 Reply Last reply

0
L Offline
L Offline
lgeyer

wrote on last edited by

#2

@
QSqlQuery query("PRAGMA table_info(" + tableName +")");
@
1 Reply Last reply

0