Re: obtain fields in table without query

Thanks I thought as much.
Obviously the data has to get to me but I'd prefer if i could ask for it directly instead of having the overhead of doing a meaningless select.
Seems silly doing a query just to throw away the data. Guess I'll just have to make my query as trivial as possible. Some sort of wrapper for DESCRIBE queries might be nice to see in DBI to solve this.

UpdateCheers Mike creating a statement without a query like that sounds what I'm looking for

Comment on Re: obtain fields in table without query

Replies are listed 'Best First'.
Re: Re: obtain fields in table without query by joealba (Hermit) on Jul 08, 2002 at 13:17 UTC
You can run a "desc table" query using DBI, although you will get some different results on different databases. MySQL returns a row of data for each column in the table -- (name, datatype, NULL (YES\|NO), key, default, auto-increment). Oracle sees this as an invalid SQL statement.	[reply]