Forgive my language, I am a newbie in QGIS. I created a spatialite layer and added 4 fields. As I was working on the project I realised that I didn't need one of the fields, and I needed to add 3 different fields, to make them 6 in total.I encountered the limitation of SQLite not being able to delete created fields. So I looked for a GUI option of modifying the database. I successfully deleted that one column and added 3 new ones. Now the problem is when I open the layer in QGIS to edit the feature attributes, only the old 4 columns are still available. My spatial layer initially had these attributes: . After updating the SQLite database using DB Browser for SQLite, below is the structure of my table from DB Browser for SQLite: Coming back to QGIS to add more information to newly created fields, I still find the old 4 fields: .
Anyone to help so that my layer loads all fields for feature attributes please?