How can I copy geometry table from spatialite?

Question

I tried spatialite:

create table Twn_free_way as select * from Twn_road;

This works fine but I can not copy the complete table.

Answer 1

A geometry column must be described in the geometry_columns metadata table.

To add this entry, use the AddGeometryColumn function:

SELECT AddGeometryColumn('tablename', 'MyGeoColumn', 1234, 'POINT');