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).

QtWS: Super Early Bird Tickets Available!

Information_schema on sqlite

3rd Party Software

2 Posts 2 Posters 4.2k Views

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