>Do you have some specific reason to want the information in that format ? <b>ALL</b> the information is generated by SQLite3 table/view by table/view; there is no wizardry here. I am of a generation who wants to <i>see what exists</i> rather than of the generation who <i>find out when the need arises</i>, especially when chasing unexpected software behaviour or when inheriting an SQLite3 application The suggested dot command would be a time-saving convenience both for debugging and documentation, nothing more.