How do single-file databases handle multi-table databases? Do they simply pack separate physical table files into a single file, or have they found a way to store in one table all the definition and data values of a database? Can someone un-curious-ify me? Thanks.
To see how SQLite does it, check out <http://www.sqlite.org/arch.html>.
