[IC] sql-queries in interchange

Jason Kohles interchange-users@interchange.redhat.com
Sat Dec 29 15:04:00 2001


On Sat, Dec 29, 2001 at 02:38:17PM -0800, Korey G. wrote:
> Is there any way to 'head' (or to 'cat' or to 'pipe' ) the
> names of fields in an arbitrary database and to use
> that information in a list like so maybe
> 
> Or Perhaps there is a better way of doing this with Just sql Queries
> 
Depending on the database you are using, there is probably a query that
can show this information.  In MySQL you can use "show fields from table",
and the results will include table name, type, and other information.

Most sql servers have this capability, but the syntax varies...

-- 
Jason Kohles                                 jkohles@redhat.com
Senior System Architect                      (703)786-8036 (cellular)
Red Hat Professional Consulting              (703)456-2940 (office)