Re: [sqlite] Reading Database Schema Info. in Perl

2005-04-05 Thread Matt Sergeant
On 30 Mar 2005, at 04:05, [EMAIL PROTECTED] wrote: I need to be able to read all table names in the database, and further all attribute names in each table. ( am using DBD::SQLite in Perl) For gathering all the table names I've used the sqlite_master table. The problem is that the information on

Re: [sqlite] Reading Database Schema Info. in Perl

2005-03-31 Thread Jan Stürtz
Use PRAGMA table_info. - Jan On 30.3.2005 11:05, [EMAIL PROTECTED] wrote: I need to be able to read all table names in the database, and further all attribute names in each table. ( am using DBD::SQLite in Perl) For gathering all the table names I've used