I am using QspatiaLite in QGIS 2.14. I am having problem updating a column of my table and I suspect that the types (integer, real, text etc.) are not consistent.

How can I know which are the types of the fields of my table imported from QGIS into QspatiaLite?

1 Answer 1


You can check the CREATE TABLE statement with SQL. Spatialite-gui has a special menu tool for that : right-click the table name and choose 'Show columns'

But you can get the answer with ogrinfo as well:

ogrinfo my_spatialite_db.sqlite -sql "SELECT sql FROM sqlite_master WHERE type = 'table' AND name = 'my_table'"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.