Spatialite Views

creation of a view runnable on spatialite and compliant with qgis:

CREATE VIEW ucs_2013 as
select
    rowid as rowid,
    ucs2007 as ucs2007,
    geometry as geometry
from
    ucs2013;



insert into views_geometry_columns(view_name,view_geometry,view_rowid,f_table_name,f_geometry_column,read_only)
values('ucs_2013','geometry','rowid','_ucs2013','geometry',1);



IS IMPORTANT TO USE THE ALIAS OTHERWISE THE QGIS SPATIALITE PROVIDER COULD WORK BAD
ALSO IS IMPORTANT TO HAVE THE ROWID field available in the view.