SQLite Forum

partial file load?
Login
see my response just before; here is a formatted version of the script:

```
SELECT 
  'n'||'='||count(*)||'+'||group_concat(namelen,'+') as db_schema
FROM (
  select name, name||'='||length(sql) as namelen, type from sqlite_master
  WHERE type = 'table' and name not like 'Persistent%'
  order by name
  )
group by type
;
```