Right.  Each database should have description tables for tables, indexes, etc.

In Oracle, you can use:

select column_name, data_type, nullable from all_tab_columns 
where table_name = :1 order by column_id

-----Original Message-----
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:30 PM
To: Anthony Nickolayev
Cc: [EMAIL PROTECTED]
Subject: Re: How can I fetch column names?


Which database?  It usually varies.

On Jun 10, Anthony Nickolayev scribed:

> Greetings. Maybe the answer for my question will be RTFM, but i still cant find
> it myself. The problem is: i need to fetch just list, contains column names - and
> i dont know how to do it. I didnt find it in DBI manual page, and anywhere else.
> Thanks anyway, and sorry for my english.
>

Reply via email to