Not that I would suggest it, but you could create a separate database for each table and then attach the databases to a single connection to join data together. The indexes will need to be in the same database as the table they index.
But why do you want each table in a different file? Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Guilherme C. Hazan [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 3:10 PM To: sqlite-users@sqlite.org Subject: [sqlite] storing the tables in separate files Hi, From what i seen, sqlite stores all tables in a single file. Is there an easy way to change this behaviour and store the tables and indexes in separate files? thanks guich ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------