Both are in there, not all drivers implement data_sources, and to get column names for a table you have to first execute a select * from tbl where 1=0, and then retrieve the column names as attributes of the statement handle - the oreilly dbi book tells you how
-----Original Message----- From: Mike Taylor [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 12:18 To: [EMAIL PROTECTED] Subject: Discovering Table and Columns Stop me if this is a FAQ, but I couldn't find it in DBI::FAQ at http://dbi.symbolstone.org/doc/faq.html nor in the Pirate(:-) FAQ at http://tlowery.hypermart.net/perl_dbi_dbd_faq.html Are there any plans to extend the DBI interface with methods for discovering what databases are accessible from a driver, what tables exist in a database and/or what columns make up a table? It's bothering me that a Java-oriented friend of mine is able to do these things with JDBC, but I don't seem to be able to them in DBI. Thanks in advance. _/|_ _______________________________________________________________ /o ) \/ Mike Taylor <[EMAIL PROTECTED]> www.miketaylor.org.uk )_v__/\ "There was a time when nostalgia wasn't so popular. Those were the days" -- Ian Ridley, writing in the _Observer_ P.S. Whatever happened to http://www.symbolstone.org/tidbits? ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. **********************************************************************
