vendredi 6 novembre 2015

Pragma in Select request

I wanna to retrieve column's names and rows count in a table in SQLite. Is it possible to do this is one command?

SELECT COUNT(*) FROM tablename

and

PRAGMA table_info(tablename))

Aucun commentaire:

Enregistrer un commentaire